Re: left/right join concept

2008-03-01 Thread Rob Wultsch
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

Re: left/right join concept

2008-03-01 Thread Brent Baisley
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