Michael Stassen wrote:
It's a bug:
<http://bugs.mysql.com/1677> <http://bugs.mysql.com/1591> <http://bugs.mysql.com/3765>
Depending on which bug report you look at, this result is either because mysql treats this as a nested join, or because mysql does not support nested joins. Frankly, I find the explanations make no sense.
- not sure myself why a left join followed by a right join is a "nested join", but a right join followed by a left join isn't... If you write the query as:
select * from E right join B on e = b left join C on e = c;
... it returns the expected results.
- but thanks for the help.
- ian
-- | Ian Sales Broadband Solutions for | | Database Administrator Home & Business | | PlusNet plc http://www.plus.net | + ----------- PlusNet - The Smarter Way to Internet ----------------+
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
