Member Avatar for 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
  • 2 Contributors
  • 6 Replies
  • 172 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by newbie14
Member Avatar for pritaeas 
SELECT clientID, clientName 
FROM tblClient
WHERE clientStatus='a' 
AND clientID NOT IN (SELECT clientID FROM tblCDSValidity)
ORDER BY clientName
Member Avatar for newbie14

Dear Prit,
It works great thank you very much.

Member Avatar for pritaeas

Please mark this thread as solved.

Member Avatar for newbie14

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

Member Avatar for pritaeas

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

Member Avatar for newbie14

Dear Prit,
Ok done. Thank you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.