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
