Archives of the TeradataForum

Message Posted: Fri, 06 Aug 2004 @ 14:34:31 GMT

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

<-- Anonymously Posted: Friday, August 06, 2004 14:05 -->

Hi All,

Reg: the Union problem I will elaborate a little more,

The table structure is like this

     create table aaa
     (
     aa char,bb char ,cc char .....qq char)

What we are doing is something like this

     select aa as d1, bb as d2......qq as d16 from aaa
     UNION
     select qq as d1, aa as d2......pp as d16 from aaa
     UNION
     .....
     select   bb as d1,cc as d2.............aa as d1

something like above.

Every field is a char & every select have same number of fields , nulls are possible...

Hope this helps!!!

Thanks

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