in mssql also its "NOT IN" but it can be used only for a single field.

select * from table1 where (f1) not in (select f1 from table2 )