Select a.商品编号,a.商品名称,b.进货金额,b.进货总量,c.销售总量,c.销售金额
from spb a left join (Select 商品编号,sum(库存量) 进货总量 ,sum(进价) as 进货金额 from
kcb group by 商品名称) b on a.商品编号=b.商品编号
left join (Select 商品编号,sum(数量) as 销售总额 ,sum(销售价) as 销售金额 from
xshb ) c on a.商品编号=c.商品编号
order by a.商品编号
select xshb.编号,spb.名称,isnull(sum(库存量*进价),0),库存量,进价,xshb.数量,isnull(sum(数量*销售价),0) from spb
full outer join kcb on spb.编号=kcb.编号
full outer join xshb on xshb.编号=kcb.编号
select a.商品编号,a.商品名称, b.库存量 + c.数量 as 进货总量,
(b.库存量 + c.数量) * b.进价 as 进货金额, c.数量 as 销售总量,
c.数量 * 销售价 as 销售金额
from spb a left join kcb b on a.商品编号 = b.商品编号
left join xshb c on a.商品编号 = c.商品编号