Find un identical rows from two Tbls based on combination of 3 columns
-
I need to Find un identical rows from two table based on combination of 3 columns. Both table has same structure. Using SQL Server 2005 Ie Table1 and Table2 to has the columns Type,ID,Parent 1. Query the rows from Table1 which are not matching in Table2 with respect to columns Type,ID,Parent (ie. Need not required the rows which are matching combination of Type,ID,Parent in both table) 2. Query the rows from Table2 which are not matching in Table1 with respect to columns Type,ID,Parent (ie. Need not required the rows which are matching combination of Type,ID,Parent in both table) Please help!!
-
I need to Find un identical rows from two table based on combination of 3 columns. Both table has same structure. Using SQL Server 2005 Ie Table1 and Table2 to has the columns Type,ID,Parent 1. Query the rows from Table1 which are not matching in Table2 with respect to columns Type,ID,Parent (ie. Need not required the rows which are matching combination of Type,ID,Parent in both table) 2. Query the rows from Table2 which are not matching in Table1 with respect to columns Type,ID,Parent (ie. Need not required the rows which are matching combination of Type,ID,Parent in both table) Please help!!
Here's[^] some nice basic info about joins and how to do them. It even has pictures
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
I need to Find un identical rows from two table based on combination of 3 columns. Both table has same structure. Using SQL Server 2005 Ie Table1 and Table2 to has the columns Type,ID,Parent 1. Query the rows from Table1 which are not matching in Table2 with respect to columns Type,ID,Parent (ie. Need not required the rows which are matching combination of Type,ID,Parent in both table) 2. Query the rows from Table2 which are not matching in Table1 with respect to columns Type,ID,Parent (ie. Need not required the rows which are matching combination of Type,ID,Parent in both table) Please help!!
Did you try to write query before you ask here? In your previous question you took good answers which are valid for your question which you are asking.
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.