delete from emp
where
    EMP_CODE in (
select
    EMP.EMP_CODE
from
    EMP
    inner join EMP_INVALID
        on emp.EMP_CODE = EMP_INVALID.EMP_CODE
        and EMP_INVALID.VALID_FLG <> '1'
)