SELECT TABLE01.[DUPLICATE_PROVED_01]
FROM TABLE01 AS T1
INNER JOIN TABLE02 AS T2
ON T1.[DUPLICATE_PROVED_01] = T2.[DUPLICATE_PROVED_02]
/* OR */
SELECT TABLE01.* FROM
TABLE01
WHERE TABLE01.[DUPLICATE_PROVED_01]
IN ( SELECT TABLE02.[DUPLICATE_PROVED_02] FROM TABLE02 )