delete from
    EMP
where
    EMP_CODE in (
        select
            EMP.EMP_CODE
        from
            EMP,
            EMP_INVALID
        where
            EMP.VALID_FLG != "1"
            and EMP.EMP_CODE == EMP_INVALID.EMP_CODE
    )