Multiple joins ...

chanduin4u@yahoo.co.in · **Posted:** Tue Jul 22, 2008 2:27 pm

Here is my situation.
I have a person mapping file, address mapping file and phoneNumbers.

relation exist between person, phonNumber and person, address
can any one give me the Hql query to get these fields
1. phoneNumber(phoneNumber)
2.addressline1(address)
3.FirstName(person)

based on the lastname of the person.
please help me to solve this

wolli · **Posted:** Wed Jul 23, 2008 2:58 am

Code:

select p.FirstName, a.Addressline1, pn from Person p
inner join p.Address a
inner join p.PhonNumber pn
where p.LastName = "myname";

If you don't want the whole pn object, use pn.PhoneNumber or whatever you need.