Hello,

I have one to many foreign key...

something like Person and Phone Numbers...


I need to write select that returns all persons with their phone numbers...

There is object Person and PhoneNumber

SELECT person FROM Person person JOIN FETCH PhoneNumber num ORDER BY person.name;

This query returns 5 record with 2 Persons... but I need to return 2 Person objects with his PhoneNumbers (Set) as property of Person.

sorry for my english... ;) I hope, that it is clear...

miso

ok,

I tranformate question:

How Can I get array of unique Persons with phoneNumbers???

Is this OK???


or there is another way to do this??

thanks, miso