Query help

[newbie14]

Dear All,
I got a query where I would like to select the clientName from tblClient but with condition that this clientID does not exist in another table call tblCDSValidity. I tried like this but it failed.

SELECT tblClient.clientID, tblClient.clientName FROM tblClient,tblCDSValidity Where tblClient.clientStatus='a' And tblClient.clientID!=tblCDSValidity.clientID ORDER BY tblClient.clientName

[pritaeas]

SELECT clientID, clientName 
FROM tblClient
WHERE clientStatus='a' 
AND clientID NOT IN (SELECT clientID FROM tblCDSValidity)
ORDER BY clientName

[newbie14]

Dear Prit,
It works great thank you very much.

[pritaeas]

Please mark this thread as solved.

[newbie14]

Dear Prit,
I cannot find the option to mark it solved?

[pritaeas]

It's below, near the reply box. A text-link "mark as solved" if I remember correctly.

[newbie14]

Dear Prit,
Ok done. Thank you.