I'll defer to you. At 01:00 PM 5/28/2007, Baron Schwartz wrote: >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]