Compare combination of two column with combination of other two in SQL

Question

I have 2 tables, tbl_NameCode and tbl_Bkp both having columns ID and Name.

I have to select records from tbl_NameCode which are not in tbl_bkp.

SELECT * FROM tbl_Bkp 
WHERE ? */COMBINATION OF ID,Name NOT IN (SELECT COMBINATION OF ID,NAME FROM tbl_NameCode )*/

How to compare the combination of two columns with combination of other two?

Answer 1

If am not wrong Except operator should work.

SELECT Id1,Id2,Id3,..Name FROM tbl_Bkp
Except
select Id1,Id2,Id3,..Name from tbl_NameCode