hi
I have to join two views and a table where they have a cloumn in common,
i tried as follows but its not working

Csystem, ASystem are views
SysAgreement is a table

Actual SQL to be converted into HQL is

FROM CUSTOMER_SYSTEM_INFO SYS,ASUP_SYSTEM_INFO ASUP,SYSTEM_AGREEMENT SA
WHERE SYS.SIP_ID=ASUP.SIP_ID(+) AND SYS.SIP_ID=SA.SIP_ID(+)

from Csystem as sys right join ASystem as asup,
SysAgreement as sa left join sys
where sys.sipId = asup.sipId and sys.sipId=sa.sipId

Basic problem here is views doesnt have primary keys to map to other tables

Any solution for joining views by HQL

Mallik