关于 group by分组问题

Question

老师，看您说分组查询的是如果是两个表只根据一张表里的某个字段分组，查另一张表分组是没问题的您看我这条sql报那个语法错误
select max(tr.update_time) as updateTime,
       ts.product_img      as productImg,
       ts.product_url      as productUrl,
       tr.product_name     as productName,
       count(tr.id) as number
from t_recom_selling_record tr,
     t_recom_selling ts
where tr.product_code = ts.product_code
  and tr.group_agent_code = '2111010008'
group by tr.product_name

Answer 1

翔仔 2021-12-09 23:09:57

同学好，group by 默认是要包含select的字段。