Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e64Ji5S20467 for ; Tue, 4 Jul 2000 15:44:05 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id PAA28211; Tue, 4 Jul 2000 15:43:52 -0400 (EDT) To: Antti Linno cc: pgsql-sql@postgresql.org Subject: Re: Antw: LEFT JOIN In-reply-to: References: Comments: In-reply-to Antti Linno message dated "Tue, 04 Jul 2000 16:34:22 +0300" Date: Tue, 04 Jul 2000 15:43:52 -0400 Message-ID: <28208.962739832@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200007/26 Antti Linno writes: >> I think, the following select will solve your problem >> >> select first.id >> from first >> except >> second.id_first >> from second; >> > Nay, I got parse error. Should be ... EXCEPT SELECT second.id_first ... Anyway, we should have full ANSI join support in 7.2, or 7.1 if we get lucky. regards, tom lane