Archives of the TeradataForum

Message Posted: Wed, 13 Oct 2004 @ 11:31:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You are trying to achieve something like {(A-B) U B }, which is similar to just {A U B}.

So I guess you could use:

     Insert into table_copy
     Sel * from table
     Union
     Sel * from mtable;

Narayan

	<Prev	Next>		<<First	<Prev	Next>	Last>>