DELETE FROM
    EMP as a
WHERE
    a.EMP_CODE in (
        SELECT
            b.EMP_CODE
        FROM
            EMP_INVALID as b
    )
    and a.VALID_FLG = "0";