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 nhus...@googlegroups.com.
To unsubscribe from this group, send email to 
nhusers+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.


Reply via email to