Archives of the TeradataForum

Message Posted: Wed, 10 Oct 2001 @ 13:47:51 GMT

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

Geoffrey Rommel wrote:

As evidenced by some of my obfuscated queries, double quotes can be used like single quotes if you put a "c" character directly after the double quotes. For example:

Sel "Table A"c as some_column;

This use of double quotes treats the quoted material as a string literal rather than as a name. Note that in the above example I included an "as" alias. This is important because without it the parser interprets the "c" character as an alias.

Thus:

sel "table a"c;

Is equivalent to

sel "table a" as c;

But not equivalent to

sel "table a"c as c;

So to rewrite your specific query you could do the following:

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

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