The minimum mysql version should be changed to 5.0.12, possibly even 5.0.1. Check out http://dev.mysql.com/doc/refman/5.0/en/join.html for more information about nested joins. Nested joins are allowed as of 5.0.1, and the join processing was changed as of 5.0.12 to be compliant with standard SQL.
My hosted server is running 5.0.95 which can handle these joins, and I have just modified it locally, but thought that those users who can't change their mysql version and are running a new enough version of 5.0.x should be able to make use of this module too.

Comments

elstudio’s picture

Status: Active » Needs review
StatusFileSize
new435 bytes

Here's a patch to update the minimum MySQL version to 5.0.12.