Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Oct 2001 @ 20:31:12 GMT


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


Subj:   Re: Execution Plans for ANSI vs non_ANSI formatted SQL
 
From:   Geoffrey Rommel

  Perhaps one of our more theoretical list members would care to comment on the relational differences between your original ON/WHERE version and my ON only one.  



This thorny question is discussed, a bit sketchily perhaps, in the SQL Reference.

V2R3: SQL Reference, Vol. 3, pp. 17-14 - 17-22 ("More on Outer Joins"), esp. "ON Clauses and WHERE Clauses", p. 17-18.

V2R4.0: SQL Reference, Vol. 6, pp. 2-30 - 2-34 ("Coding ON Clauses With WHERE Clauses for Outer Joins").


--wgr



     
  <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