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.
Brent Baisley
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,
please?
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
