Help with a query 1

[TitleistDBA]

I have two tables that should be the same.
in FHDWHSDB.dbo.Results I have 1846191 rows
in FHECOMDB.dbo.Results I have 1846182 rows
I need to identitfy the missing 9 rows. But the query I'm trying is just not working. Can anybody help with this?


SELECT n.*
FROM FHDWHSDB.dbo.Results n
WHERE NOT EXISTS (Select *
from FHECOMDB.dbo.Results m, FHDWHSDB.dbo.Results n
WHERE m.business_Unit = n.business_unit and
m.Sales_Organization = n.Sales_Organization and
m.Order_Number = n.Order_Number and
m.Order_Suffix = n.Order_Suffix)

http://www.acushnetcompany.com

 

[r937]

select n.*
  from FHDWHSDB.dbo.Results n
left outer
  join FHECOMDB.dbo.Results m
    on n.business_Unit      
     = m.business_unit 
   and n.Sales_Organization 
     = m.Sales_Organization 
   and n.Order_Number       
     = m.Order_Number 
   and n.Order_Suffix       
     = m.Order_Suffix 
 where m.business_unit      is null
   and m.Sales_Organization is null
   and m.Order_Number       is null
   and m.Order_Suffix       is null

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[donutman]

One null check is all you need, isn't it? You can't join on a null can you...brain fart.
-Karl


[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[r937]

doh!

i was gonna say something about primary keys, then i realized that those columns might not be in the primary key, then i decided to leave all 4 conditions in...

but you're right, any one of them will do

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[TitleistDBA]

Thanks for the help..That got me the rows that I needed!

http://www.acushnetcompany.com