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