Re: Antw: [SQL] LEFT JOIN

[Tom Lane]

Antti Linno <[EMAIL PROTECTED]> 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