Outer joins
От | T.Steubesand@fh-trier.de |
---|---|
Тема | Outer joins |
Дата | |
Msg-id | D1EBA02F1B1BD211818F006008A2F4190152FD@vwntserver.fh-trier.de обсуждение исходный текст |
Ответы |
Re: [ADMIN] Outer joins
Re: [ADMIN] Outer joins |
Список | pgsql-admin |
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 по дате отправления: