This content has been marked as final. Show 3 replies
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
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.
I´m sorry I made an other mistake.
the query in my first posting works too