At 11:10 -0500 25/4/06, gerald_clark wrote:
Yes. 3.23 was not correct in the order of precedence. This has been answered many times here.
Sorry - I haven't been on the list all that long.
You need to change your comma join to an inner join.
Lovely! That's it - many thanks. At 17:15 +0100 25/4/06, Philippe Poelvoorde wrote:
in 5.0.12 comma precedence was changed : http://dev.mysql.com/doc/refman/5.0/en/news-5-0-12.html
I did look at this but, my understanding of joins still being somewhat shaky, I didn't take in its full implications.
so try with parenthesis, your implicit join and left join should then works correctly.
In fact it's easier in my script to use inner join as Gerald suggested. Many thanks for your patience though.
-- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ I think I think; therefore I think I am. -- Ambrose Bierce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
