Horton

Re: Antw: LEFT JOIN

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Antti Linno <alligator@all.ee>
Cc: pgsql-sql@postgresql.org
Date: 2000-07-04T19:43:52Z
Lists: pgsql-sql 
Antti Linno <alligator@all.ee> 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