Hi,
I have below query in Oracle:

select d.company_id, d.app_id, d.acm_service_id
from acm_service d, company e, application f where
d.company_id = e.company_id
and d.app_id(+)= f.app_id

Can some one help and advise what would be the corresponding HQL for this. Consider acm_service,company and application as enity(in hibernate world.)