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