select a.ypbh,a.mc,a.gg,a.dw,(a.sl-isnull(b.sl,0)) as 库存,
a.jj as 入库价格总计,b.jj as 出库价格总计,
(a.jj-isnull(a.jj,0)) as 库存价格总计
from
(select ypbh,mc,gg,dw,sum(sl) as sl,sum(jj)*sum(sl) as jj from yk_rkyp group by ypbh,mc,gg,dw) a
left join
(select ypbh,sum(sl) as sl,sum(jj)*sum(sl) as jj from yk_ckyp group by ypbh) b
on a.ypbh=b.ypbh我这个样(group by ypbh)的话只能适合那种一个编号的药品一个价格的情况,是不是如果一个编号的药品不同的价格就没有办法统计了,只能按编号和批号排序啊?那样的话其不是不能统计同一编号药品的库存了啊?
a.jj as 入库价格总计,b.jj as 出库价格总计,
(a.jj-isnull(a.jj,0)) as 库存价格总计
from
(select ypbh,mc,gg,dw,sum(sl) as sl,sum(jj)*sum(sl) as jj from yk_rkyp group by ypbh,mc,gg,dw) a
left join
(select ypbh,sum(sl) as sl,sum(jj)*sum(sl) as jj from yk_ckyp group by ypbh) b
on a.ypbh=b.ypbh我这个样(group by ypbh)的话只能适合那种一个编号的药品一个价格的情况,是不是如果一个编号的药品不同的价格就没有办法统计了,只能按编号和批号排序啊?那样的话其不是不能统计同一编号药品的库存了啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货