CODE EXAMPLE FOR SQL

sql find duplicate records in two tables

SELECT  *   
FROM TableA A  
WHERE NOT EXISTS (SELECT *      
                  FROM TableB B
                  WHERE A.NUM = B.NUM);