From: Nathan Young <nyoung@asis.com>
To: pgsql-sql@postgresql.org
Date: Fri, 22 Nov 2002 11:44:20 -0800
Reply-To: nathan@ncyoung.com
Organization: N.C. Young Design
Message-Id: <MHTPHEXXXSIELH1XSDBVSPOZYE9BA.3dde8914@inky>
Subject: join question
MIME-Version: 1.0
Content-Type: text/plain; charset="windows-1252"

Hi all.

I have a table with members and a table with payments.  Each payment is 
related to a member by memberID and each payment has (among other things) a 
year paid.

I can create a join to find a list of members who have paid for a given year 
(2002 in this case):

select member.memberID,member.name from member, payment where 
payment.memberID = member.memberID and payment.yearPaid = 2002

I would like to be able to get a list of members who have not paid for a 
given year.

I would also like to combine the two criteria, for example to generate a list 
of members who have paid for 2002 but not 2003.

Thanks in advance!

--->Nathan


---
(([^/]+)/([^/]+)){0,1}/*(([^/]+)/([^/]+)){0,1}/*(([^/]+)/([^/]+)){0,1}/*
(([^/]+)/([^/]+)){0,1}/*(([^/]+)/([^/]+)){0,1}/*(([^/]+)/([^/]+)){0,1}/*
---


Nathan Young
N. C. Young Design
(530)629-4176
http://ncyoung.com