Re: Antw: LEFT JOIN

From: Erol Oz <eroloz(at)bilgi(dot)edu(dot)tr>
To: Antti Linno <alligator(at)all(dot)ee>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Antw: LEFT JOIN
Date: 2000-07-04 14:54:03
Message-ID: 3961FA8B.F80D9216@bilgi.edu.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rybarczyk Mikolaj 2000-07-04 15:16:17 ODP: Antw: LEFT JOIN
Previous Message Antti Linno 2000-07-04 13:34:22 Re: Antw: LEFT JOIN