Received: from all.all.ee (puu.all.ee [194.204.49.113]) by hub.org (8.10.1/8.10.1) with ESMTP id e64DYUS59885 for ; Tue, 4 Jul 2000 09:34:30 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id QAA29665 for ; Tue, 4 Jul 2000 16:34:22 +0300 Date: Tue, 4 Jul 2000 16:34:22 +0300 (EEST) From: Antti Linno To: pgsql-sql@postgresql.org Subject: Re: Antw: LEFT JOIN In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200007/23 > 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. Antti