Hi
I have not understand why you tell that you have 3 tables. HQL is based on
core model (mapping files) not on SQL tables.
You must write the query in hql and you must use objects in your core model
not id :
select dm.id, dm.drug_name, sum(cds.qty_available)
from drug_master dm
left join cds_drugstore.drug_master cds
and cds.cds_id = 1
and cds.source_id = 'sourceName'
and cds.source_type = 'c'
group by dm.id
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
