Hi All,

I am having two tables A and B. A is having its primary key x which is a foreign key to B. My hql is like
Select something From A a join a.somename
added mapping with A mapping file is
<many-to-one name="somename" class="B" column="x">
Pojo is having setter,getter of B class with is having name as somename.

But its generated sql is :
Select something from A a inner join B b on a.primary key of A = b.primary key of B

I want the primary key of A only in the queries left join part.


I am new to the technology. If AnyOne can resolve my problem, I will be thankful to him.

Thanks In Advance,
Gopal

Try the following HQL:

SELECT a
FROM A AS a
LEFT JOIN FETCH a.somename

Cheers,
Roger

Thanks Rogger but.......

If I join a table with another table whose primary key is foreign key to first table, The same query works fine. But When I join a table to another table which is having first one's primary key as defined in my problem. The second table makes join with its primary key, not with the foreign key having itself . May be somewhere I am doing mistake in mapping. Please suggest me a way to do.


Thanks,
Gopal