Received: from mailproxy.de.uu.net (mailproxy.de.uu.net [192.76.144.34]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA27wpl23533 for ; Thu, 2 Nov 2000 02:58:51 -0500 (EST) (envelope-from DieringG@eba-haus.de) Received: from kopo001 ([149.228.241.118]) by mailproxy.de.uu.net (5.5.5/5.5.5) with SMTP id IAA05244 for ; Thu, 2 Nov 2000 08:58:35 +0100 (MET) Received: from EBA_DO-Message_Server by kopo001 with Novell_GroupWise; Thu, 02 Nov 2000 08:56:25 +0100 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Thu, 02 Nov 2000 08:55:53 +0100 From: "Gerhard Dieringer" To: Cc: Subject: Antw: Outer Joins Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id eA27wql23534 X-Archive-Number: 200011/12 X-Sequence-Number: 43 >>> "Marc Rohloff" 01.11.2000 09.02 Uhr >>> > > select a.col1, b.col2 from a,b > where a.col1 = b.col2 > or b.col2 is null > This query has nothing to do with an outer join. See the following example: table a c1 --- x y and table b c2 --- x Then an outer join gives: select a,c1, b.c2 from a left outer join b on a.c1 = b.c2 c1 | c2 x | x y | (null) but your query gives: select a.c1, b.c2 from a, b where a.c1 = b.c2 or b.c2 is null c1 | c2 x | x because there are no rows in table b with c2 is null ------------- Gerhard