On Mon, 2 Nov 1998 T.Steubesand@fh-trier.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@polkaroo.net Ingenia Group - Software Kinetics Ltd.
http://polkaroo.net/~ahayes http://www.sofkin.com