SELECT
a.business_id,
a.depot_pos,
GROUP_CONCAT(stock_code) AS concat_stock_code
FROM
dpb_wms_depot_pos AS a
LEFT JOIN dpb_wms_goods AS c ON a.depot_pos = c.depot_pos
WHERE
a.business_id = 8
GROUP BY
a.depot_pos
现在这样时只查询三个字段的值是能够查询到数据的,如果我还想再查a表中的dppos_id,添加到select后边就会报错,报错信息:SELECT list is not in GROUP BY clause and contains nonaggregated column 'dpb.a.dppos_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by;他说选择列表不在GROUPBY子句中;
哪位大佬知道这个问题怎么解决,我还想获取其他字段的值的问题?