This content has been marked as final.
Show 3 replies
-
1. Re: EJB-QL join with UNIDIRECTIONAL relationship
micho Feb 26, 2007 4:24 PM (in response to micho)In simple SQL I wrote
select ug.* from usergroup ug, user u, user_usergroup u_ug where (ug.sid = u_ug.userGroupList_sid) and (u.sid = u_ug.user_sid) and u.name='john'
and jot the expected result.
What do I have to code in EJB-QL -
2. Re: EJB-QL join with UNIDIRECTIONAL relationship
micho Feb 26, 2007 5:17 PM (in response to micho)I wrote now:
select ug from UserGroup as ug, User as u where ug member of u.userGroupList and u.name = 'john'
that works! :-)
is it possible to wrtite it with a join. -
3. Re: EJB-QL join with UNIDIRECTIONAL relationship
micho Feb 26, 2007 6:22 PM (in response to micho)I´m sorry I made an other mistake.
the query in my first posting works too