DELETE FROM
    EMP as E
WHERE
    E.EMP_CODE IN (
        SELECT
            E2.EMP_CODE
        FROM
            EMP as E2 LEFT OUTER JOIN
            EMP_INVALID as EI ON E2.EMP_CODE = EI.EMP_CODE
        WHERE
            E.VALID_FLG != "1"
    )