Table A OneToMany <-> ManyToOne Table B ManyToMany <-> ManyToMany Table C
I want to select rows of Table A by checking if a specific column of Table C includes the values passed via named param.
The Idea was to get all entities of Table B by checking if JoinTable (TableBC) the join value of Table C includes all the (as params passed) values in a subquery and then get the rows of Table A that include the result we got from the subquery.
Pseudocode:
SELECT ta FROM TableA ta JOIN TableB tb WHERE tb.id IN (SELECT tb.id FROM tb JOIN tb.EntitiesOfTableC tc WHERE tc.id IN :ParamIds)
Always end up with "Could not extract ResultSet" error or some other problem.
Pseudo-Database-Schema:
