Dave Dyer wrote:
Thanks, it turns out you are exactly right. I rewrote
the query to keep the "on" immediately following the "left join"
and it now works as I wish.
I'll have to read up on "cross join", but if there
is a mysql bug here, it is that the parser that what I
wrote as "left join" was turned into a cross join.
-- the second "on" clause in a row ought to have triggered
a complaint.
Yes, I too thought that should be an error. I have tried to figure out whether
it's illegal to have two in a row or to omit an ON or USING clause, but I can't
convince myself completely by referring to
http://dev.mysql.com/doc/refman/5.0/en/join.html. I'm not sure I am reading it
correctly. But it does seem the parser should reject it.
If you want to pursue this further I won't duplicate your effort, but I'm happy
to dig deeper on it and see if there is a bug.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]