Query Question

[Jeff]

Hello All

Thanks in advance to anyone with assistance here (And I must say I always
get the best help on here - you guys are all amazing - thank you)

I have a Table called Clients with about 435 records
I have a Table called DoorTracker with about 180 Records
These 2 tables area linked through a field called Client ID in both tables
(the door tracker table is a tracking table for certain data for any given
client in the database)
The Door Tracker table can only have a Client ID once (Unique field)

Can I write a query that will give me a list of all Clients in the Clients
table that are not currently in the DoorTracker table - I know there has to
be a way to easily do this and I cant seem to figure it out.

Any help on this will be great - and if you need any additional details
please let me know.

Thanks again.

Jeff

 

[Guest]

Good job describing the tables, field names, and primary keys plus what you
are looking for. Hopefully my SQL below is as good.

SELECT Clients.[Client ID]
FROM Clients LEFT JOIN DoorTracker ON Clients.[Client ID] =
DoorTracker.[Client ID]
WHERE DoorTracker.[Client ID] Is Null;