Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Problem with Union
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023