delete
from EMP
where
    EMP_ENG_NAME in (
        select EMP_ENG_NAME from EMP_INVALID
    )
    AND EMP.VALID_FLG <> '1'
;