主题：sql中的SUM报错

cmd1.CommandText = "SEL ECT {SPKCB}.SPDM AS 商品代码, {GUIGE1}.GGMC AS 颜色, {GUIGE2}.GGMC AS 尺码, sum(SL) AS 数量, {SPTP}.pic_name AS 图片 from (({SPKCB} INNER JOIN {GUIGE1} ON {SPKCB}.GG1DM = {GUIGE1}.GGDM) INNER JOIN {GUIGE2} ON {SPKCB}.GG2DM = {GUIGE2}.GGDM) INNER JOIN {SPTP} ON {SPKCB}.SPDM = {SPTP}.SPDM where ckdm = 001 and {SPkcb}.sl > 20 ORDER BY {SPKCB}.SPDM DESC"

蓝老师，这个是要怎么修改啊

.NET Framework 版本：4.0.30319.42000

Foxtable 版本：2021.5.29.1

错误所在事件：

详细错误信息：

选择列表中的列 'SPTP.pic_name' 无效，因为该列没有包含在聚合函数或 GROUP BY 子句中。