DELETE FROM EMP_INVALID WHERE
    emp_code IN (SELECT emp_code FROM EMP_INVALID)
    AND
    emp_code NOT IN (SELECT emp_code FROM EMP WHERE VALID_FLG = 1)
;