I've seen it described here before, but I can't seem to find it. select a from t1 where a not in (select b from t2);
will find the resultset I'm looking for, and it seems OK when the resulting in () list is small (maybe < 1000). But it seems less than ideal when the resulting list is large. Isn't there a join I can do to accomplish the same a little more elegantly? Thanks! -Clark
