Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Brent Baisley (brenttechgmail.com)
Date: Sat Mar 01 2008 - 12:02:13 CST
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 just the opposite.
An outer join doesn't filter the table, it just finds any matching
content if it's present. Anything without matching content has a
"null" where normal matched content would be.
PHP, MySQL, Linux, Mac
I write code
On Mar 1, 2008, at 4:16 AM, Thufir wrote:
> 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 or correct,
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?