1.SELECT
a.id,a.app_id,b.app_price,b.month_appid,b.insert_date
FROM
t_times_order a
LEFT JOIN (SELECT * FROM t_monthapp ORDER BY month_appid DESC) b ON a.app_id = b.app_id
GROUP BY a.id ORDER BY a.id DESC
针对left join 排序(SELECT * FROM t_monthapp ORDER BY month_appid DESC) ,在mysql版本5.6都还能实现,5.7版本无法实现
(测试过版本5.6.27,5.6.29都可行,5.7.17不行)
5.6.27版本测试结果:
5.7.17版本测试结果: