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