Archives of the TeradataForum

Message Posted: Tue, 25 Nov 2008 @ 20:17:23 GMT

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

The correct way would be to place that SELECT statement in the FROM clause and simply cross join to it. As a derived table you will need you alias the aggregate column as well.

Hope this helps.

-Rob

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