主题：[求助] 求数量加总

Number和FQty 是哪个表的列？

From {ICInventory} Inner JOIN {t_Item}： Number和FQty 是这2个表其中哪个表的列？

Select  Number,FName,FQty From ( select [FItemID],Number,sum(FQty ) as FQty  from {ICInventory} group by [FItemID],Number) as a Inner JOIN {t_Item} ON {t_Item}.[FItemID] = a.[FItemID]

导出这2个表的数据测试

请上传实例测试

cmd.CommandText = "Sel ect a.FFullNumber,b.FName,a.FQty From ( sel ect [FItemID],FFullNumber,sum(FQty ) as FQty  from {ICInventory} group by [FItemID],FFullNumber) as a Inner JOIN {t_Item} ON {t_Item}.[FItemID] = a.[FItemID]"

导出这2个表结构看看。

select a.*,FName from (Select {ICInventory}.[FItemID] FFullNumber,sum(FQty) as FQty From {ICInventory} Inner JOIN {t_Item} ON {t_Item}.[FItemID] = {ICInventory}.[FItemID] group by {ICInventory}.[FItemID],FFullNumber) as a Inner JOIN {t_Item} ON {t_Item}.[FItemID] = a.[FItemID]

这个应该是代码问题了，错误所在事件：窗口,窗口1,Button8,Click

把sql拿到数据库执行有没有问题？