Thanks for your advice. I do not know how to solve this:
Given
Entity A
ID
Field A1
Multi valued association to Entity B
And
Entity B
ID
Field B1
Field AID (reference to A)
I want all records from table A, where B.B1 = 'abc'
This would be the SQL I´d use:
select * from table a
join tbl b on a.ID = b.AID
where b.b1='abc'
Or:
select * from table a where exists
(select 1 from table b where b.aid=a.id and b.b1='abc')
The second form would return entities of type A.
What would the first form return and how do I access the values?
Thank you!