Re: Antw: [SQL] LEFT JOIN

[Erol Oz]

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