delete emp
from
    EMP as emp
inner join
    EMP_INVALID as inv
on
    emp.EMP_CODE = inv.EMP_CODE
where
    emp.VALID_FLG = 0