Archives of the TeradataForum

Message Posted: Tue, 09 Oct 2001 @ 20:24:14 GMT

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

This should work:

  select '''Table A''', sum(product_cost)
  from mytable
  union all
  select '''Table B''',sum(product_cost)
  from mytable2;

Dara Tressler

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