SELECTsum(d.go),sum(a.letter1),a.region_id1,d.region_idFROM dwds AS a right JOIN power AS d ON d.platform_id = a.platform_id1 AND d.region_id = a.region_id1 AND d.time = a.time1WHERE `time` BETWEEN 1535040000 AND 1535126399 or `time1` BETWEEN 1535040000 AND 1535126399GROUP BY a.platform_id1,a.region_id1上面是我现在的查询语句,问题就处在当表a有多条数据的时候,就会依据表d的多条数据去重复相加,这样得出的结果就是表d数据条数的倍数,各位大佬,帮忙看下,应该怎么做修改,对了还有就是,这个是用在tinkphp框架里面的,如果大佬们能改成tinkphp的写法,就万分感谢了
é¦å ï¼ææçä½ or没ç¨æç½ï¼è¯¥æ¬å·æ¬èµ·æ¥çå°æ¹æ²¡æ¬èµ·æ¥ã
ç¶åï¼ä½ å¯ä»¥å æa表åd表åå«æ±æ»ï¼ç¶ååå ³èèµ·æ¥ã
select sum(d.go),sum(a.letter1),a.region_id1,d.region_idå¦å¤ï¼ä½ a.region_id1åd.region_idæ¯ç¸ççï¼ä½ selectéé½æ¥åºæ¥å¹²åï¼
a.region_id1åd.region_idè¿ä¸¤ä¸ªåªæ¯å¨æµè¯çæ¶åæå°åºæ¥æ¹é¢çæ°æ®çï¼ä½ è¿ä¸ªæ¹æ³å¦å°äºï¼æå æµè¯ä¸ï¼ççä½ åçè¯å¥åºè¯¥ä¸æ¯å¾å¤§çé®é¢æ¥çï¼è°¢è°¢äºå·