主题：inner join 找不到供应商简称列

指定表名，即可，如

select {供应商}.供应商简称,

比如

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

那试试

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

如果还有问题，做一个foxtable实例发上来测试

改成这样，如

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