I have a Query with three Entitys: a) Employee b) Customer c) Mandatory

Each Employee has a Mandatory (employee.mandatory_fk) Each Customer has a Mandatory (customer.mandatory_fk)

Every Employee and Customer has a Birthdate. Now I want to get all Customer and Employee of a Mandatory.

This is my query: select e, c from Employee e, Customer c WHERE c.mandatory.id = 1 OR e.mandatory.id = 1

But the current problem is: I got only one row? But for example: I have one employee and one customer: I want to have to rows (one row for the customer and one row for the employee)

How can I do this? Where is the issue in my query?

Thank you for your help