From: Nathan Young <nyoung@asis.com>
To: pgsql-sql@postgresql.org
Subject: join question
Date: Fri, 22 Nov 2002 11:44:20 -0800
Message-ID: <MHTPHEXXXSIELH1XSDBVSPOZYE9BA.3dde8914@inky> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: nyoung@asis.com
Subject: Re: join question
In-Reply-To: <MHTPHEXXXSIELH1XSDBVSPOZYE9BA.3dde8914@inky>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox