Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
melon.melon
Yak Posting Veteran
76 Posts |
 Posted - 2008-08-25 : 12:06:32
|
| There are two tables that should contain the same data values (though there are nulls) with column names slightly different. My question is, how to compare the data from the two tables and select only those rows where the data in any given column does not match and adding a count to count the no. of unmatched?Example how one database is (suppose to have at least 50 columns and many data values). There is another database that contains similar data but slightly diff column names.id name food 1 susan maggi mee 1 susan mee2 mike laksa2 mike curry2 mike chicken3 billy laksa 3 billy chicken4 ben null5 sandy meeDo i need to use Join method? How do i do this? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
|
|
|
|
|
Compare data in two tables (filter unmatched data)