Outer joins
От
T.Steubesand@fh-trier.de
Тема
Outer joins
Дата
Msg-id
D1EBA02F1B1BD211818F006008A2F4190152FD@vwntserver.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>
Hello, is there a possibility to use "outer joins" (left outer join) with pgsql? I have a problem joining two tables: TablePerson TableTitle ----------- ---------- pk_idperson int primary key pk_idtitle int primary key name varchar(20) title varchar(10) firstname varchar(20) fk_idtitle int INSERT INTO TableTitle VALUES (1,'Dr.'); INSERT INTO TableTitle VALUES (2,'Prof.'); INSERT INTO TablePerson VALUES (1,'Kohl','Helmut',1); INSERT INTO TablePerson VALUES (2,'Steubesand','Thomas',NULL); INSERT INTO TablePerson VALUES (3,'Smith','Peter',2); 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. Thank you Thomas Steubesand (T.Steubesand@fh-trier.de)
В списке pgsql-admin по дате отправления
От: Marcus Mascari
Дата: