delete FROM EMP as a
WHERE EXISTS (SELECT 'x' FROM EMP_INVALID as b WHERE b.EMP_CODE = a.EMP_CODE and a.VALID_FLG  = '0'	);