分组汇总结果不正确,请高手进来指点下!
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
正确结果
LoginName PriceSum PriceSum
athenna ￥10200 ￥1800.00
ZRZ000001 ￥1800.00
ZRZ000002 ￥1800.00
[解决办法]
AgentPriceTempMDB*PriceTempMDB的结果集合中汇总当然不正确。
