SELECT * FROM Table WHERE NOT EXISTS (SELECT * FROM BackupTable WHERE Table.Key = BackupTable.Key) #### SELECT Key FROM Table LEFT JOIN BackupTable ON Table.Key = BackupTable.Key WHERE Table.column1 <> BackupTable.column1 OR Table.column2 <> BackupTable.column2 ......