Horton

Re: Antw: LEFT JOIN

Erol Oz <eroloz@bilgi.edu.tr>

View thread View on postgr.es
From: Erol Oz <eroloz@bilgi.edu.tr>
To: Antti Linno <alligator@all.ee>
Cc: pgsql-sql@postgresql.org
Date: 2000-07-04T14:54:03Z
Lists: pgsql-sql 

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