改成这样,如
Select b.供应商简称, sum(fa piao金额) from {进项fa piao} As a inner join {供应商} As b on a.供应商简称=b.供应商简称 group by b.供应商简称