hello guys,
my hql is not so hot... could anyone help me with this query?
<query name="Orders.CountHowManyTimesTheseArticlesWereBought">
select sum(l.Quantity), a.Id
from OrderLine l
inner join l.Article as a
inner join l.Order as o
where a.Id in (:articleIds)
and o.Timestamp >= from
and o.Timestamp <= until
</query>
it won't even compile the way it is...
--
Jan
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.