delete from EMP where EMP_CODE IN
(select EMP.EMP_CODE
    FROM EMP AS a
    INNER JOIN EMP_INVALID AS b ON a.EMP_CODE = b.EMP_CODE
WHERE a.VALID_FLG = 0);