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 |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-05-21 : 10:08:23
|
| Hi,Ive got 2 tables, both have 30 fields. The first table is the most recent updated version of the 2nd. I wrote a simple select statement to find the differences between the 2 entirely. I wrote a left join and where the fields on the right side table are null and did not get the right results.Im looking for all the fields that are on the left table that dont appear on the right one and also there will be slightly similar rows on both tables but the table on the right has afew of the columns with different figures to the columns which are the same. So really just looking for the entire difference between the 2 but more interested in the differences in the left table.Any ideas? hope that makese sense. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-21 : 10:15:36
|
You can use FULL JOIN on primary key column(s).
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
|
|
|
|
|
Left Join