老乌龟再问你一下啊

select 药品批号,药品编号,sum(数量),sum(金额) from tb group by 药品批号,药品编号

对每个批号统计金额?
select a.ypbh, a.sl-isnull(b.sl,0) as 库存,a.je as 入库金额,b.je as 出库金额,a.je-isnull(b.je,0) as 结余金额 from
(select ypbh,sum(sl) as sl ,sum(je) as je from yk_rkyp group by ypbh) a
left join
(select ypbh,sum(sl) as sl ,sum(je) as je from yk_ckyp group by ypbh) b
on a.ypbh=b.ypbh

这个样的话如果再想获取此编号药品的其它信息，是不是要再嵌套到药品表查询啊？