Archives of the TeradataForum

Message Posted: Wed, 26 Nov 2008 @ 14:05:22 GMT

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

          > sel
          > a.infokey,
          > a.infodata,
          > b.num_tables
          >
          > from
          >     dbc.dbcinfo a ,
          >     (sel count(*) num_tables  from dbc.tables where tablekind='T') b
          > ;

Polesh, it was not me who posted this question but the person who did had explicitly said:

"When I try stuff like that in Teradata, the SQL crashes. Is there a technique I can use to simulate a select statement as a column in Teradata? I know I can do a cross join in the from clause, but is there a way to put it into the select clause."

The method you are suggesting is exactly a cross join with a derived table so the answer to your question is: No, this is not the answer to the original query.

Victor

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