RSS feed

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

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

FEB 5 2009

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?

 

How to create a new table using existing tables >>

<< How do I start SQL Server 2008 Services

 

COMMENT

*Name:
*Comment:
You can use HTML tags here.
*Code: Please enter the sum of 5+2