Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.
Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).
select * from table1 a left outer join table2 b on a.id=b.id where b.id is null This will give you all records in table1 that aren't in table2, assuming id is the common key.
