find a value that doesn't exsists in table2 but in table1

[magmo]

Hi


I have 2 database tables with a common column, I would like to find all records that exsists in table2 but not in table 1. I guess this is a easy task, but I'm lost right now.....

Regards

 

[SQLDenis]

select * from table1 t1 left outer join table2 t2 on
t1.id =t2.id
where t2.id is null

http://sqlservercode.blogspot.com/

 

[r937]

nice one, SQLDenis, but i think it's this instead --

select * from table2 t2 left outer join table1 t1 on
t2.id =t1.id
where t1.id is null




r937.com | rudy.ca

 

[SQLDenis]

You are right

Should have been a right join instead

http://sqlservercode.blogspot.com/

 

[r937]

okay, that works, but you'd have to change your WHERE clause too

r937.com | rudy.ca

 

[magmo]

Hi


Great, Thanks for the help!



Regards