To simplify what I want to do...
I have table1 and table2. I want to select the records in table1 that are not in table2. I know I can do this by the following:
select t1.name, t1.address from t1 where t1.id not in (select t2.id from t2)
But is there a faster way? The only field in t2 is "id".