groupby 和left join

select * from so_android_hour sah group by open_third_party left join so_plan sp on sah.open_third_party=sp.sell_no limit 10;

词条语句报错：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘left join so_plan sp on sah.open_third_party=sp.sell_no limit 10‘ at line 1

select * from so_android_hour sah left join so_plan sp on sah.open_third_party=sp.sell_no limit 10;没有 group by open_third_party正常执行。

结论groupby和join不能用在一条语句

groupby 和left join

原文：https://www.cnblogs.com/huiandong/p/10099828.html