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").


  <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: 15 Jun 2023