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
Дата:
От: Guido Weber
Дата:
Сообщение: Re: [ADMIN] Outer joins
FAQ