查询A表的某个字段在B表中的所有数量

查询A表的某个字段在B表中的所有数量

– 查询群表zc_chat_group 的classCode对应量表zc_user_flow 的chat_code有多少

UPDATE zc_chat_group `group` INNER JOIN(
SELECT 
	c.counts AS sums,
chat.class_code
FROM
	zc_chat_group chat
LEFT JOIN(
	SELECT 
		class_code,
		COUNT(*) counts
	FROM
		zc_user_flow flow
	WHERE
		flow.group_status = '2'
	GROUP BY
		flow.class_code
) c
ON chat.class_code = c.class_code
 )s
ON `group`.class_code = s.class_code
 SET  cur_count = s.sums