join question
От | Nathan Young |
---|---|
Тема | join question |
Дата | |
Msg-id | MHTPHEXXXSIELH1XSDBVSPOZYE9BA.3dde8914@inky обсуждение исходный текст |
Ответы |
Re: join question
|
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: