用以下代码即可 SELECT a.a, ISNULL(SUM(CASE b.e WHEN 'y' then 1 else 0 end ),0) as e, ISNULL(SUM(CASE b.f WHEN 'y' then 1 else 0 end ),0) as f, ISNULL(SUM(CASE b.g WHEN 'y' then 1 else 0 end ),0) as g FROM ta a LEFT JOIN tb b ON b.b like '%'+a.a+'%' GROUP BY a.a效果图