Hi there,
maybe some HQL query guru can help me out there...

Let's say in my structure I have users, which are related to roles. A user has roles and they determine what the user can do in the system.
File categories are also related to roles and only users having at least one of the roles a category has, can access that category. The query I need is something like:

select c from Category c, User u where c.roles "has at least one of" u.roles

(User is the argument to the query)

Sorry I don't get to know how to really work with joins, ...


Thanks for any help,
Ignacio