there are multiple ways of doing this. some of other methods are1. SELECT A,BFROM TableAEXCEPTSELECT A,BFROM TableB2. SELECT a.A,a.B FROM TableA a LEFT JOIN TableB b ON a.A = b.A AND a.B = b.B WHERE b.A IS NULL3. SELECTFROM TableA aOUTER APPLY(SELECT A FROM TableB WHERE A= a.A AND B = a.B )bWHERE b.A IS NULL 4.SELECT A,BFROM( SELECT A,B,'A' AS Tab FROM TableA UNION ALL SELECT A,B,'B' FROM TableB)tGROUP BY A,BHAVING SUM(CASE WHEN Tab = 'B' THEN 1 ELSE 0 END) = 0
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs