SELECT AgentPriceTempMDB.LoginName, Sum(AgentPriceTempMDB.PriceSum) AS PriceSum之Sum, PriceTempMDB.LoginName, Sum(PriceTempMDB.PriceSum) AS PriceSum之Sum1
FROM AgentPriceTempMDB, PriceTempMDB
GROUP BY AgentPriceTempMDB.LoginName, PriceTempMDB.LoginName;
为什么这条语句执行分组汇总结果不正确?
AgentPriceTempMDB
LoginName PriceSum
athenna ￥10,200.00
PriceTempMDB
LoginName PriceSum
athenna ￥600.00
athenna ￥600.00
athenna ￥600.00
ZRZ000001 ￥600.00
ZRZ000001 ￥600.00
ZRZ000001 ￥600.00
ZRZ000002 ￥600.00
ZRZ000002 ￥600.00
ZRZ000002 ￥600.00