Archives of the TeradataForum

Message Posted: Tue, 03 Aug 2004 @ 12:52:00 GMT

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

try something like this :

     sel a.date, a.col1, a.col2, b.col3, b.col4
     from

     (sel date, col1, col2
     from table1) as a(date,col1,col2),

     (sel date, col3, col4
     from table2) as b(date,col3,col4)

     where a.date = b.date

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