how to write stored hql query

chanduin4u@yahoo.co.in · **Posted:** Thu Jul 17, 2008 1:14 pm

Hello friends,
I have some doubts on how to write a stored hql query.
i have to tables and they are dependent with a primary key id.
eg

persondetail Contact No.
firstname type
lastname number
Id id
.... .....
in the above two tables i want to use joins and get the first, last names of person with number = ........... where person details id= contact no id
can you help me out...

zafarjcp · **Joined:** Sun May 18, 2008 1:21 pm **Posts:** 13

can you eleborate Stored hql and give your mapping information so will generate a query for you.

chanduin4u@yahoo.co.in · **Posted:** Thu Jul 17, 2008 3:05 pm

I have two tables.

person details

Id
lastname
firstname
nickname
....

Phonenumber

type
Id
PhoneNumber
.....

the above are the two tables that we have to map to
can you help me out to write a stored hql query.
i need the result set of Firstname and Lastname of a particular phoneNumber .

chanduin4u@yahoo.co.in · **Posted:** Thu Jul 17, 2008 3:06 pm

I have two tables.

person details

Id
lastname
firstname
nickname
....

Phonenumber

type
Id
PhoneNumber
.....

the above are the two tables that we have to map to
can you help me out to write a stored hql query.
i need the result set of Firstname and Lastname of a particular phoneNumber .

chanduin4u@yahoo.co.in · **Posted:** Thu Jul 17, 2008 3:06 pm

I have two tables.

person details

Id
lastname
firstname
nickname
....

Phonenumber

type
Id
PhoneNumber
.....

the above are the two tables that we have to map to
can you help me out to write a stored hql query.
i need the result set of Firstname and Lastname of a particular phoneNumber .