34,593
社区成员
发帖
与我相关
我的任务
分享
select b.货位,sum(b.数量),sum(b.数量*a.定价)as '合计金额' from b left outer join a on b.id=a.id
group by b.货位
select b.货位,b.数量,sum(b.数量*a.定价)as '合计金额' from b left outer join a on b.id=a.id
group by b.货位,b.数量
select b.货位,b.数量,b.数量*a.定价 as '合计金额' from b left outer join a on b.id=a.id
select B.货位,B.数量,A.定价*B.数量 as 合计金额
from B
inner join A on A.条码 = B.条码