select t1.*,t1.零售价 * t1.总库存 as 库存金额,
t2.数量,t2.销售金额
from [库存$] t1 left join (
select 店铺名称,款号,
sum(数量) as 数量,
sum(销售金额) as 销售金额
from [销售$]
group by 店铺名称,款号
) t2
on t1.款号 = t2.款号 and t1.店仓名称 = t2.店铺名称
select t1.*,t1.零售价 * t1.总库存 as 库存金额,
t2.数量,t2.销售金额
from [库存$] t1 left join (
select 店铺名称,款号,
sum(数量) as 数量,
sum(销售金额) as 销售金额
from [销售$]
group by 店铺名称,款号
) t2
on t1.款号 = t2.款号 and t1.店仓名称 = t2.店铺名称