| From: | Amos Hayes <ahayes(at)polkaroo(dot)net> |
|---|---|
| To: | T(dot)Steubesand(at)fh-trier(dot)de |
| Cc: | pgsql-admin(at)postgreSQL(dot)org |
| Subject: | Re: [ADMIN] Outer joins |
| Date: | 1998-11-02 14:43:02 |
| Message-ID: | Pine.LNX.3.96.981102093628.5312A-100000@smurf.ingenia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, 2 Nov 1998 T(dot)Steubesand(at)fh-trier(dot)de wrote:
> SELECT name,firstname,title
> FROM TablePerson,TableTitle
> WHERE TablePerson.fk_idtitle = TableTitle.pk_idtitle;
>
> results: Kohl Helmut Dr.
> Smith Peter Prof.
>
> How can I force pgsql to return the following result:
> Kohl Helmut Dr.
> Steubesand Thomas
> Smith Peter Prof.
How about putting an entry like (3,'') into TableTitle and assigning an
fk_idtitle of 3 to people without a title.
--
Amos Hayes
ahayes(at)polkaroo(dot)net Ingenia Group - Software Kinetics Ltd.
http://polkaroo.net/~ahayes http://www.sofkin.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastian Windhorst | 1998-11-03 13:28:39 | ODBC readonly |
| Previous Message | Guido Weber | 1998-11-02 14:35:07 | Re: [ADMIN] Outer joins |