hi,

Below is the SQL Query that I was facing difficulty in converting to HQL.

SELECT EMP.EMP_CODE,EMP.EMP_STATUS_ID,EMP.FILE_CODE,EMP.SSN,EMP.DATE_CREATED,EMP.FLAG_DW,SU.USER_ID,SU.PASSWORD,,SGM.ROLE_ID FROM CA_EMP_MASTER EMP,CA_EMP_LOGIN SU, CA_EMP_ROLE SGM, CA_EMP_DAY_IN CLK WHERE SU.EMP_CODE=EMP.EMP_CODE AND CLK.EMP_CODE (+) = EMP.EMP_CODE AND SGM.EMP_CODE=SU.EMP_CODE AND EMP.EMP_CODE=?";


Problem is with the " CLK.EMP_CODE (+) = EMP.EMP_CODE ". Help me out of the situation.

thanks in advance,

pravi

http://www.hibernate.org/hib_docs/v3/re ... ryhql.html

I think you can just type left outer join or right outer join.

somethin like