hql语句 new vo的问题
首先是3张表:客户表 CstCustomer ,订单表Orders ,在线订单表OrdersLine
select C.custName, sum(B.oddCount*B.oddPrice)from Orders A ,OrdersLine B,CstCustomer C where A=B.orders and A.odrCustomer=C.custNo group by A.odrCustomer
这样写是没错的,是我要的结果
但是封装vo就报没有合适的构造函数,可是带参的不带参的我都给了啊
select new com.ty.crm.vo.RecordVo(C.custName, sum(B.oddCount*B.oddPrice))from Orders A ,OrdersLine B,CstCustomer C where A=B.orders and A.odrCustomer=C.custNo group by A.odrCustomer
请大家帮帮忙!!!