1.利用find_in_set配合使用group_concat的结果集
SELECT * FROM t_grade WHERE
(SELECT GROUP_CONCAT(t_charge.id) FROM t_charge) IS NOT NULL
AND NOT FIND_IN_SET(t_grade.gradeId,(SELECT GROUP_CONCAT(t_charge.id) FROM t_charge))
1.利用find_in_set配合使用group_concat的结果集
SELECT * FROM t_grade WHERE
(SELECT GROUP_CONCAT(t_charge.id) FROM t_charge) IS NOT NULL
AND NOT FIND_IN_SET(t_grade.gradeId,(SELECT GROUP_CONCAT(t_charge.id) FROM t_charge))