finding unique entries between two tables

[jontracey]

Hi

Probably a simple question but my brain has just broke

I have two tables, both have almost identical data but I need to find out which lines are different

so table 1 has 10000 lines, table 2 has 10200 lines, I need to find a way to show only those that are not in table 1

Hope this make sense.

Thanks

Jon

 

[dixondwayne]

say you have table1 and table2
table1=10000 rows
table2=10200 rows

both are keyed on rowid


select rowid from table2 where
rowid not in (select rowid from table1)