Hi,

i want to know how to write this two query in Hibernate using createCriteria along with projections.

1.
select sum(setteld_bal) from account_balances where clientaccount = 84 and bal_type_ind=1
union
select sum(setteld_bal) from account_balances where clientaccount = 84 and bal_type_ind=2

2.
select sum(setteld_bal), bal_type_ind from account_balances where clientaccount = 84 and bal_type_ind in (1,2)
group by bal_type_ind

Hibernate doesn't support UNION yet.

Another approach recommended by the Architect, was to use a view to generate your data and have hibernate map a Value Object to that view.