Thanks for your advice. I do not know how to solve this:
Multi valued association to Entity B
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
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?