Removing data from a table

[mchambers]

I was wondering if someone can give me a hand.

I have 2 tables. One table has all my clients and the other table has clients that received a certain set of services. I want to join those two tables and remove the clients that received the set of services so that I only get the clients that have not received the services yet. I have tried to pull them out but it is not working. Can anyone help me with this. Thanks

 

[lespaul]

something like this:

SELECT * FROM Clients C
LEFT OUTER JOIN Services S on C.ClientID = S.ClientID
WHERE C.clientID is null

you may want to read up on JOINS, here's an article that i've found helpful Understanding SQL Joins

Leslie

 

[mchambers]

I got it I just had to do the following: in the query properties I had to set unique properties to yes.

But thanks very much for your help!