EJB-QL join with UNIDIRECTIONAL relationship

[micho]

I have a UNIDIRECTIONAL ManyToMany Relationship between useres and usergroups. Users know their usergroups, usergroups don´t know their users.

I want to create a query to get all Usergroups which are referenced by a User with name 'john'

I tried:

select ug from UserGroup as ug, User as u join u.userGroupList where u.name = 'john'

but got an empty result, what´s wrong?

@Entity
public class User implements Serializable
{ ...
 public String getName()
 @ManyToMany
 public List<UserGroup> getUserGroupList()

@Entity
public class UserGroup implements Serializable
{ ..
}

[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

[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.

[micho]

I´m sorry I made an other mistake.
the query in my first posting works too