I just strated out with the OpenAccess framework and modeled, the following data structure:
User <--> UserRole <--> Module
So a many to many relation exists between User and UserRole and a many to many relation exist between UserRole and Module.
The OpenAcess framework has hidden the two many-to-many junction tables.
I now want to run a query which gives me all Modules for a given user.
When I execute the following query I get the runtime exception "Join left side undefined".
What am I missing here?