Re: [ADMIN] Outer joins
От
Amos Hayes
Тема
Re: [ADMIN] Outer joins
Дата
Msg-id
Pine.LNX.3.96.981102093628.5312A-100000@smurf.ingenia.com
Ответ на
Outer joins (T.Steubesand@fh-trier.de)
Список
Дерево обсуждения
Outer joins T.Steubesand@fh-trier.de
Re: [ADMIN] Outer joins Amos Hayes <ahayes@polkaroo.net>
Re: [ADMIN] Outer joins Guido Weber <guido@castor.atlas.de>
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
В списке pgsql-admin по дате отправления
