日期:2014-05-17 浏览次数:20508 次
select b.货位,sum(b.数量),sum(b.数量*a.定价)as '合计金额' from b left outer join a on b.id=a.id group by b.货位