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)
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 |