Marco wrote:
Michael Stassen wrote:
What do you mean, it doesn't work?
Michael
Marco wrote:
The query
> select * from a join b on a.x = b.y;
works on mySQL 3.23.56 but doesn't work on mySQL 3.23.58. I had to change it in
> select * from a,b where a.x = b.y;
Is it a well-known behavior or is it a bit strange?
Thanks, Marco
The join on syntax works on 3.23.56 but doesn't work on 3.23.58
Repeating yourself won't help. The query
select * from a join b on a.x = b.y;
is perfectly valid syntax and should produce the same result in 3.23.56 and 3.23.58. You need to say what you mean by "doesn't work". Do you get an error message? If so, what is it?. Do you get unexpected results? If so, what are they, and what were you expecting? Either way, I'm guessing that what you've posted here is an example, rather than your real query. As your example is valid syntax, it seems likely that the problem stems from something in your real query. Therefore, it would be better to post the real query.
In other words, we can't diagnose the problem until you describe in detail what is wrong.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
