This content has been marked as final.
Show 2 replies
-
1. Re: ejb-select traversing CMR collections
aloubyansky Jun 19, 2004 3:58 AM (in response to stscit04)select c.id from A a where in(a.bs) b, in(b.cs) c where a.id = ?1
-
2. Re: ejb-select traversing CMR collections
stscit04 Jun 21, 2004 6:48 AM (in response to stscit04)Thanks for your reply.
Your code didnt work, but it tipped me off
into the right direction. The working
statement is:
select c.id from A a, in (a.bs) b, in (b.cs) c WHERE a.id = ?1
Regards,
Stefan