select loan.l_ID_number ,sum(loan.l_money) from loan,mainInfo where loan.l_ID_number=mainInfo.m_ID_number and mainInfo.m_addr like '1155______' group by loan.l_ID_number
select max(price) from PubSaleProductVO as product join product.pubsaleInfos as info where product.id=? 本来报跟lz一样的错,后来改成 select max(info.price) from PubSaleProductVO as product join product.pubsaleInfos as info where product.id=? 就OK了
起个别名,hql可以用sum函数.被你的下划线和l给搞晕了,呵呵.
本来报跟lz一样的错,后来改成
select max(info.price) from PubSaleProductVO as product join product.pubsaleInfos as info where product.id=?
就OK了