Select records from tble-A where no records in tbl-b meeting crit.

[Guest]

I have a one to many relationship between table-A and table-B. I need to
list records from table-A where records from a selected group of records in
table-B are not found. Ex. Members and MembershipDues Tables. Want to
determine which members have not paid their quarterly dues.

 

[John W. Vinson]

I have a one to many relationship between table-A and table-B. I need to
list records from table-A where records from a selected group of records in
table-B are not found. Ex. Members and MembershipDues Tables. Want to
determine which members have not paid their quarterly dues.

A NOT EXISTS clause will help here:

SELECT TableA.<whatever fields you want to see>
FROM TableA
WHERE NOT EXISTS
(SELECT MemberID FROM TableB WHERE TableB.MemberID = TableA.MemberID
AND <whatever other criteria you want>)


John W. Vinson [MVP]

 

[Guest]

Thank you for the assistance!
Have a great Thanksgiving!

 

[Marshall Barton]

I have a one to many relationship between table-A and table-B. I need to
list records from table-A where records from a selected group of records in
table-B are not found. Ex. Members and MembershipDues Tables. Want to
determine which members have not paid their quarterly dues.

SELECT M.MemberName, M.MemnerAddress, . . .
FROM Members As M LEFT JOIN MembershipDues As D
ON <M.ID = D.MemberID
WHERE D.MemberID Is Null
AND D.PaidDate >= quarterstartdate