It appears from other messages on this board that hibernate will attempt to use subselects with MySql even when the version of MySql does not support them. Is there some way to tell hibernate not to use subselects when creating the query or is the only option to rewrite the hibernate query a different way.

Thanks

Upgrading to a database is the only other option, I think.