Received: from exchange.bilgi.edu.tr (prol800.ibun.edu.tr [194.27.149.22]) by hub.org (8.10.1/8.10.1) with ESMTP id e64EsdS52955 for ; Tue, 4 Jul 2000 10:54:44 -0400 (EDT) Received: from bilgi.edu.tr (AKA610-2 [10.0.10.14]) by exchange.bilgi.edu.tr with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id MMKH8NR7; Tue, 4 Jul 2000 17:49:06 +0300 Message-ID: <3961FA8B.F80D9216@bilgi.edu.tr> Date: Tue, 04 Jul 2000 17:54:03 +0300 From: Erol Oz X-Mailer: Mozilla 4.72 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: Antti Linno CC: pgsql-sql@postgresql.org Subject: Re: Antw: LEFT JOIN References: Content-Type: text/plain; charset=iso-8859-9 Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/24 Antti Linno wrote: > > > 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. 'select' is missing after 'except'. select first.id from first except select second.id_first from second; erol > Antti