DELETE FROM EMP
WHERE EMP_CODE IN (
    SELECT EI.EMP_CODE
    FROM EMP_INVALID EI
    LEFT JOIN EMP E ON EI.EMP_CODE = E.EMP_CODE
    WHERE EI.VALID_FLG = '0' AND E.VALID_FLG != '1'
);