Archives of the TeradataForum
Message Posted: Fri, 26 Oct 2001 @ 20:31:12 GMT
| 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").