qq_39793857的博客

记录一个mysql联合查询加分组的报错： In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'tsbio.sl.id'; this is incompatible with sql_mode=only_full_group_by我也是第一次遇到这个问题，sql明明是很普通的联合查询 left join on 最后加了一个分组 group by 却报这样...