there is no merge statement in ms sql server, i have a merge statement like this (see below). Is there a (new) statement which works like merge of...

thanks for the reply...

but what is the sql statement if it is NOT IN instead of IN

select * from table1 where (f1, f2) not in (select f1, f2 from table2...