Somewhat tangential, but for whatever it is worth I agree with the
view expressed at
http://weblogs.sqlteam.com/jeffs/archive/2008/02/13/on-right-outer-joins.aspx:
Right joins should be avoided (IMHO).
> Anything to add or correct, please?
--
Rob Wultsch
--
MySQL General Mailing List
For lis
That sounds like the technical answer. I prefer an analogy a 5th
grader could understand. If you have 2 overlapping circles, and inner
join is the area that overlaps. A left/outer join is the all of the
left circle plus the content of the right circle that overlaps. A
right/outer join is ju
I'm trying to understand the terminology a bit.
A left or right join can only exist for an outer join. For an inner
join, the terminology would be out of context because inner joins are
symmetrical (whereas outer joins are asymmetrical).
Would this be a correct understanding? Anything to add
