Outer joins

From: T(dot)Steubesand(at)fh-trier(dot)de
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Outer joins
Date: 1998-11-02 14:05:33
Message-ID: D1EBA02F1B1BD211818F006008A2F4190152FD@vwntserver.fh-trier.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Steubesand(at)fh-trier(dot)de)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Weber 1998-11-02 14:35:07 Re: [ADMIN] Outer joins
Previous Message Marcus Mascari 1998-10-31 19:16:17 PLEASE...SOMEONE COMMENT: PostgreSQL 6.4BETA not using indexes with subselects