optimal sql

how can i find all records by pk in table 1 which are not in table 2

is this efficient:?

select * from t1 where pk not in (select pk from t2) Received on Mon Dec 09 2002 - 05:04:13 CST