DELETE FROM EMP
WHERE EXISTS (
 SELECT 1 FROM EMP_INVALID
 WHERE EMP.EMP_CODE = EMP_INVALID.EMP_CODE
)
AND VALID_FLG = '0';