select blah from table1 t1 where not exists (select 1 from table2 t2 where t1.blah = t2.blah ) #### select blah from table1 minus select blah from table2