comparing tables in SQL 2008

[AndyInUK]

Hi, I have got a test table in A database with user details. Now i have imported temp table in B database with user details. Now i want to match if test & temp table contains same set of users, if not then display the extra number of users in either of the table. In temp and test table only matching value could be email id. How can i achieve this ? Thank You Andyyy

[David Mujica]

Try something like this: select emailID,'Missing from B' from db_A.dbo.table1 where emailID not in (select emailID from db_B.dbo.table2) UNION select emailID,'Missing from A' from db_B.dbo.table2 where emailID not in (select emailID from db_A.dbo.table1) That should show you the differences.