Am using Hibernate on Postgres
So I am using HQL query and in HQL to use a left outer join the two entities must be assosiated..
And I cannot assosiate those two entities at this point cos it may tweak the existing data.
So i wanted an immidiate alternative for left outer join..
And i got it..
select code.batchno, (select detailA.batchfee from Detail detailA
where detailA.id= code.id),( select detailB.batchfee from Detail detailB where detailB.id= code.id) from Code code where code.category = categoryA order by code.id