Hi,

I have following HQL which involves right outer join

SELECT count(*) FROM CholdersMain cm right outer join UserInfo ui on ui.strAcctNum=cm.strAcctNum where ui.intOrgID=312

in above query, CholdersMain , UserInfo are objects which are mapped to table

when I ran above query, following error occurs

Error : unexpected token: on near line 1, column 96 [SELECT count(*) FROM com.mypackage.data.CholdersMain cm right outer join UserInfo ui on ui.strAcctNum=cm.strAcctNum where ui.intOrgID=312]


basically in SQL "on" clause its failing......and UserInfo is not getting converted to com.mypackage.data.UserInfo.....any clue please

sudhir

You are thinking too much in SQL...

How are CholdersMain and UserInfo related? This relation may change how the HQL should be written, but, anyway, this should work:

SELECT count(*) FROM CholdersMain cm, UserInfo ui WHERE ui.strAcctNum=cm.strAcctNum AND ui.intOrgID=312

Hope this helps.
Bye.