Archives of the TeradataForum

Message Posted: Thu, 27 May 2004 @ 23:03:26 GMT

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

Teradata does not require a from clause in a select statement. If - using the information in the select list and the where clause - the resolver finds exactly one object for each name, the parser will process the statement.

Some time ago, this was tightened up because it lead to confusion and possible wrong results with correlated subqueries, but it is still possible to write select statements where you can get away without including a from clause. The view you found is very, very old (it goes back to version 1). Since it has not broken, we haven't fixed it.

I tend to always include a from clause in my selects. Force of habit....8)

Jon

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