[wp-hackers] Re: [ slow queries in 1.2

[Tor Bjornrud]

Alex King wrote:
> I'm pretty sure MySQL 3.23.x supports JOINs. This page seems to support 
> that:
> 
> http://dev.mysql.com/doc/mysql/en/JOIN.html

When I was saying that it didn't support "the more complicated join 
methods", I was referring specifically to this quote on the link you 
provided.

"Note that INNER JOIN syntax allows a join_condition only from MySQL 
3.23.17 on. The same is true for JOIN and CROSS JOIN only as of MySQL 
4.0.11."

So no join_conditions are reliably available for JOIN and CROSS JOIN.

~Tor