Hi,

as stated in the topic I encountered an issue with multiple joins and ms access.

I use the config taken from:

http://community.jboss.org/wiki/Databas ... oft_Access

and the jet drvier built from the sources.

Generated query looks as follows:
...
(select user3_.Id from UsersGroup usersgroup1_ inner join UsersGroups users2_ on usersgroup1_.Id=users2_.UsersGroupId inner join Users user3_ on users2_.UserId=user3_.Id)]

It seems that some parentheses are missing.

Has anyone already solved the problem or know where could I find the solution?

Thanks