SELECT * FROM (SELECT f2.分组字段1, group_concat(f2.合并字段2 SEPARATOR '+') aaa FROM (SELECT b.id,b.合并字段2,a.分组字段1 FROM 表A a INNER JOIN 表B b ON a.detailId = b.id WHERE b.sid = 7017) f2 GROUP BY f2.分组字段1 ) t2 WHERE NOT EXISTS ( SELECT * FROM(SELECT f2.分组字段1,group_concat(f2.合并字段2 SEPARATOR '+') aaa FROM(SELECT b.id,b.合并字段2,a.分组字段1 FROM 表A a INNER JOIN 表B b ON a.detailId = b.id WHERE b.sid = 7017) f2 GROUP BY f2.分组字段1 ) t WHERE(t.aaa REGEXP '^\\+' OR t.aaa REGEXP '\\+$' OR LENGTH(t.aaa) = 0) AND t2.分组字段1 = t.分组字段1 )