Archives of the TeradataForum

Message Posted: Sat, 07 Aug 2004 @ 10:43:19 GMT

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

<-- Anonymously Posted: Saturday, August 07, 2004 05:13 -->

Hi

16 tables and 16 fields is not a coincidence but a requirement... Basically we are Unioning different instances of the same table 16 times & each table have 16 fields too...

The table is a parent child relationship... But the first column have only the highest parent available and the table contains information on the highest parent only... But we need to get the relationship for each member.

eg: 1 2 3 4 5 6..16

Here 1 is the parent and 2 is its child, 3 the child of 2 and so on... And this table contains details of parents in the level of 1 only... But we need to get the childs for 2 and for 3 and for others..., this is because in the next level we need to query only on the single field to get all its child... Thats Y we went for Union the same tables with different field order 16 times, so we get combinations for alll... I might be wrong here... But logically it seemed to serve our purpose... And then was struck by this Union Issue....

Thanks for the help!!! Any more suggestions are welcome..

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