Hi everybody,I am writing a hibernate query that multiply two attributes and takes it sum, but when I use * operator,it gives error "* only allowed inside aggregate function in SELECT " . HQL query is :

****************************************************************
Select
sum(postab.subtotal),
sum(postab.tax),
sum(postab.total),
count(postab.checknum) ,
sum((postab.subtotal)*(loc.royalty)/100) From
com.infonox.hibernate.Location as loc,
com.infonox.hibernate.Postables as postab
where loc.restaurantid = postab.restaurantid

****************************************************************

Line which is creating problem is

sum((postab.subtotal)*(loc.royalty)/100) Is there any other way to take product of two attributs? your help will be greatly appreciated as it is really stumbling block in my project. Thanks in advance

Why do you ask your question again?
It has already been answered by Gavin.
http://forum.hibernate.org/viewtopic.php?t=945708

As far as I know, what you'd like to do is not possible with Hibernate 2.x. Therefore, Gavin suggested to switch to Hibernate 3.

Best regards
Sven

Thanks sven