Archives of the TeradataForum
Message Posted: Thu, 27 May 2004 @ 23:03:26 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|