I want to implement left joi n but not getting how to do?
query is:
select a.id,a.name,b.value from tableA a left join tableB b on a.id=b.id and b.typeid=5
where a.status =1 and a.type in(1,2)

tableB is the name of the property within object A that defines the mapping between tableA and tableB in your object mapping.

I have to use left join filtered by two columns of tableB. One is the pprimary key of tableA that is foreign key on tableB as well as another column of tableB.
So, I have written

select a.id,a.name,b.value from tableA a left join tableB b on a.id=b.id and b.typeid=5
where a.status =1 and a.type in(1,2)

You cannot specify an "on-clause" in HQL. The part that is usually in the on-clause when you are writing SQL has to be in the Hibernate mapping. If your additional filter b.typeid=5 is not part of the mapping, you cannot specify it diretly with the join. However, you should be able to put it in the where clause.

I will look into my mapping for this implementation..
Thanks for your suggestion.