Archives of the TeradataForum

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

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

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>>