查出产品库存=入库-出库+退货数量select r.pronum,sum(r.num)-nvl(sum(f.num),0)+nvl(sum(t.num),0) as num
from (select pronum,SUM(num) as num from Ruku group by pronum) r
left join (select pronum,SUM(num) as num from Fahuo group by pronum)f on r.pronum=f.pronum
left join (select pronum,SUM(num) as num from Tuihuo group by pronum)t on r.pronum=t.pronum
group by r.pronum 我要用hibernate把它查询出来,返回个List this.getSession.createQuery(String hql)
把sql 带进hql,可是hibernate不支持nvl这个函数,所以报错。我改怎么做才能
from (select pronum,SUM(num) as num from Ruku group by pronum) r
left join (select pronum,SUM(num) as num from Fahuo group by pronum)f on r.pronum=f.pronum
left join (select pronum,SUM(num) as num from Tuihuo group by pronum)t on r.pronum=t.pronum
group by r.pronum 我要用hibernate把它查询出来,返回个List this.getSession.createQuery(String hql)
把sql 带进hql,可是hibernate不支持nvl这个函数,所以报错。我改怎么做才能
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货