delete from
    EMP
where
    VALID_FLG <> '1'
    and exists(
        select
            EMP_CODE
        from
            EMP_INVALID
        where
            EMP.EMP_CODE = EMP_INVALID.EMP_CODE
    );