Sriraj
Being Punctuality Is Not Only Polite...It Does Not Waste Other People's Time.
Pages
ASP.NET
Sunday, 25 March 2012
How to display records if its not exist in another table
SELECT Cid,Cname
FROM Directory
WHERE NOT EXISTS
(SELECT *
FROM CompanyLoginDetails
WHERE CompanyLoginDetails.CompanyName = Directory.Cname)
end
SELECT *
FROM Directory
WHERE Cname IN (SELECT CompanyName FROM CompanyLoginDetails)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment