So sollte es gehen (eventuell noch suboptimal):
SQL-Code:
SELECT a.Name, SUM(a.cnt)
FROM (
SELECT Name, Count(*) as cnt FROM table1 WHERE name in (FeldA, FeldB, FeldC) GROUP BY Name
UNION
SELECT Name, 0 as cnt FROM table_1 WHERE (FeldA is null or name <> FeldA) and (FeldB is null or name <> FeldB) and (FeldC is null or name <> FeldC) GROUP BY Name) a
GROUP BY a.Name