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