Re: Antw: LEFT JOIN - Mailing list pgsql-sql

From Erol Oz
Subject Re: Antw: LEFT JOIN
Date
Msg-id 3961FA8B.F80D9216@bilgi.edu.tr
Whole thread Raw
In response to Re: Antw: LEFT JOIN  (Antti Linno <alligator@all.ee>)
List 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.idfrom firstexceptselect second.id_firstfrom second;

erol

> Antti


pgsql-sql by date:

Previous
From: Antti Linno
Date:
Subject: Re: Antw: LEFT JOIN
Next
From: Rybarczyk Mikolaj
Date:
Subject: ODP: Antw: LEFT JOIN