Quote:>> I've been confused for years. Why use the terms "inner" and "outer"
if they can't be taken literally? <<
Ever see a Venn diagram or Euler diagrams for sets? Circles with colors
or X's in them for sets and their elements. Draw two overlapping
circles. The X's in the intersection are the inner join elements; the
X's in one of the circles are the preserved elements, and some of them
are outside the intersection. Hope that graphic helps.
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!