I have created the following classes and mapped them with hibernate:

----------------------
Class Customer
- int customerId
- Set departments
----------------------
Class Department
- int departmentId
- Set operators
----------------------
Class Operator(extends user)
- int userId
- Set departments
----------------------

A customer can have many departments.
An department can have many operators.
An operator can belong to many departments.

I use hibernate with a mySql database.
The database does not support subqueries/subselects.

I want to make a HQL query that gets me customers by operatorId.

I have the method:
"searchCustomerByOperatorId(long operatorId)"

Which should:
Find all the customers that has an Operator with userId(operatorId) in any of its departments.

Is there anybody who can help me creating this query?

/Casualty

I found this solution:

SELECT customer FROM Customer customer, Department department, Operator operator WHERE operator.userId="+operatorId+" AND operator = any elements(department.operators) and department = any elements(customer.departments)