Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id PAA28333 for pgsql-sql@postgresql.org; Thu, 7 Oct 1999 15:27:22 -0400 (EDT) (envelope-from news) X-Authentication-Warning: hub.org: news set sender to using -f From: "Catherine Germain" X-Newsgroups: comp.databases.postgresql.sql Subject: Select of 2 tables using "left outer join" Date: Thu, 7 Oct 1999 17:39:44 +0100 Organization: Swisscom IP+ (post doesn't reflect views of Swisscom) Lines: 14 Message-ID: <7tiejb$7ml$1@pollux.ip-plus.net> X-Trace: pollux.ip-plus.net 939310507 7893 193.5.166.30 (7 Oct 1999 15:35:07 GMT) X-Complaints-To: news@ip-plus.net X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 To: pgsql-sql@postgreSQL.org Help I need some help. I want to do a select on two tables for exemple A and B, but the information on B exist or not exist. I'm use to use SQL Server there it's a left outer join. Does someone know if that is possible with postgress, and if yes how... Many thanks Catherine