Pages

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