Solutionunvalidated

Using what you have, the JPQL will be simply: `"Select sr FROM Staff s join s.adminStaffResponses sr where s.id = :staffId"` — if you wish to avoid the extra join the JPQL requires from Staff->admin_staff_responses. Tension: might not affect performance enough to be worth changing and complicating your model. Outcome: Using an intermediary class can allow you to access the admin_staff_responses table directly in JPQL.

830b5acd-87d3-4c51-9ce4-8eaa35a3866c

Using what you have, the JPQL will be simply: "Select sr FROM Staff s join s.adminStaffResponses sr where s.id = :staffId" — if you wish to avoid the extra join the JPQL requires from Staff->admin_staff_responses. Tension: might not affect performance enough to be worth changing and complicating your model. Outcome: Using an intermediary class can allow you to access the admin_staff_responses table directly in JPQL.