Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Interesting Non-ANSI SQL Select...
 
From:   Christie, Jon

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016