Date: Thu, 23 Oct 2003 14:33:09 -0400
From: yusuf0478@netscape.net
To: pgsql-sql@postgresql.org
Subject: Query Help
MIME-Version: 1.0
Message-ID: <7E2F242E.303998B7.037EC703@netscape.net>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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