Hi,
I have some problems with a select query.

I have the following classes

Person {

Set<Address> addresses;

}

Addresses {
Set<AccessRight> accessRight;

}

AccessRight {
Set<Person> members;
}

now I have a query that says:
"select person.addresses from Person person where :user in (person.addresses.accessRight.members)"...

However I get the output "could not resolve property: members of my.core.Addresses" - however, "members" is as you can see actually in accessRight...

What's wrong with my syntax? I might have to use MySQL 4, so I might not have the option to go for subqueries...
Any clues?

Thanks,
Joey