The following query is only matching the first value found in the select subquery, even though there are match for all values `SELECT p FROM Profile p WHERE p.id IN (SELECT u.group FROM User u WHERE u.id = ?1)` The subquery returns a comma separated list like: `1,2,3`. The query should return matches for all three subquery select results. Anyone know what could be wrong? Thanks.
Can you show the table structure? It seems like User.id should be your primary key. Your subquery is filtering on that, so it would seem you would only get one result.