Query Help using Except

From: yusuf0478(at)netscape(dot)net
To: pgsql-sql(at)postgresql(dot)org
Subject: Query Help using Except
Date: 2003-10-23 18:17:08
Message-ID: 1288A498.21F60EA2.037EC703@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I'm interested in finding the minimim A.id such that the following holds:

select A.charge
, B.user_id
, C.employee_id
from A
inner join B using (user_id)
inner join C using (employee_id)

except

select X.charge
, Y.user_id
, Z.employee_id
from X
inner join Y using (user_id)
inner join Z using (employee_id)

--

I can't do the following, since the number of selected columns have to match:

select A.id
, A.charge
, B.user_id
, C.employee_id
from A
inner join B using (user_id)
inner join C using (employee_id)

except

select X.charge
, Y.user_id
, Z.employee_id
from X
inner join Y using (user_id)
inner join Z using (employee_id)

Can someone help me with the query?

Thanks in advance.

__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397

Get AOL Instant Messenger 5.1 free of charge. Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message yusuf0478 2003-10-23 18:33:09 Query Help
Previous Message Matias Surdi 2003-10-23 18:12:22 Regular expression problem