delete
  from	EMP as e
 where	e.VALID_FLG = '0'
   and	exists (
   	select	'X'
   	  from	EMP_INVALID d
   	 where	e.EMP_CODE = d.EMP_CODE
);