How to get records present in one table but not in other

Published by: Sangeeta (2/5/2009 9:59:10 AM)

I have two tables with an identical data structure. There are records in both tables but they are incomplete without one another because both the tables have unique data to represent.

I need to get all the records by consolidating the two tables into one with all unique records from each table i.e. a SQL Query which will select all the records from table 2 that don’t present in table 1.

Can anyone tell me how to fix this issue?

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

How to create a new table using existing tables >>

<< How do I start SQL Server 2008 Services