dear all
i have 2 tables, lets say table A and Table B
both tables has column ID
i wonder how can i find records that appears in B.ID and not appear in A.ID
what is the SQL command in this case?
Thnks alot
Please post T-SQL question in the Transact-SQL forum at:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1
You can use the following query:
SELECT B.ID from B where B.ID NOT IN
(SELECT A.ID FROM A)
And this will return records from B which are not in A
