这个语句出错是为什么 SELECT bid bname FROM goods_sku gs LEFT JOIN brand b ON bid = gsbrand_id WHERE gssecond_category = 11dc1062efb7c9b8ea0b30b65102eb50 ORDER BY bcreated bnum GROUP BY bid
这个语句出错的原因是GROUP BY子句应该在ORDER BY子句之前，正确的语句应该是：
SELECT
b.id,
b.name
FROM
goods_sku gs
LEFT JOIN brand b ON b.id = gs.brand_id
WHERE
gs.second_category = "11dc1062efb7c9b8ea0b30b65102eb50"
GROUP BY b.id
ORDER BY
b.created,
b.num
原文地址: https://www.cveoy.top/t/topic/b2x9 著作权归作者所有。请勿转载和采集!