Two DBs Two Tables Select Differences?
Posted on 2011-05-11
I need to find rows in DB1.dbo.NewSheet1 not found in DB2.dbo.Master1 using two columns FirstName and LastName. Sounds simple but having difficulty with MSSQL running this query very long, returning many duplicates. I used 'Select Distinct' to eliminate the dups, but need to select all and insert * into DB2.
Also tried "Select Distinct DB1.dbo.NewSheet1.* ", but no good return either. Help
Select * From DB1.dbo.NewSheet1
Left Join DB2.dbo.Master1 On DB1.dbo.NewSheet1.FirstName != DB2.dbo.Master1.FirstName
And DB1.dbo.NewSheet1.LastName != DB2.dbo.Master1.LastName