I am migrating data from TableA to TableB:
TableB and A have same Columns plus tableB as some extra columns which are foreign key from other tables.
total number of records in tableA is 1000 and total number of records in tableB is 999.
How can I find out which one is the record that is not migrated from tableA to table B?
I have tried left join/right join but did not work.
Thanks in advance