Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 03 Aug 2004 @ 12:11:26 GMT


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


Subj:   Merging Result of two differnet query!
 
From:   Manish Kumar Maurya

Hi ALL

I have problem that is, I want to merge the output of two different query which r independent of each other

First query returns

     Date              col1      col2
     01/01/2004        1         2
     03.01/2004        1         2

Second query returns

     Date              col3      coll4
     02/01/2004        3         4
     03/01/2004        3         4

Result required

     Date              col1      col2      col3      col4
     01/01/2004        1         2
     02/01/2004                               3         4
     03/01/2004        1         2            3         4

Also the no of row returned can be different and the join should be according to the matching dates


Thanks in advance

MKM



     
  <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: 27 Dec 2016