Hi!

Like the query says: Get contacts in the group 7 where contacts firstname = 'tony'

I try this:
select c from Contact c INNER JOIN Groups g on g.contacts=c and c.FirstName = 'tony' and groups.GroupId = 7

and get the error:
outer or full join must be followed by path expression

There must be an simple way to do this.

Thanks

This worked:

select c from Groups g INNER JOIN g.Contacts c where c.FirstName = 'Tony' and g.groupid = 7

Toni