Please, read this:
MERGE (T-SQL)[
^] and you'll know what MERGE statement do ;)
As per i understand in this case data are compared on
IDMavad
field and if they do not match, are inserted into
Table_ResidVaSell
.
For further information about inserting, updateing and deleting data using
Merge
statement, please see
here[
^].