SELECT COUNT(*) AS NameCount
FROM Table1 t1 INNER JOIN
Table1 t2 ON t1.ID = t2.ID
WHERE (t1.name = 'a') AND (t2.name = 'b')
FROM Table1 t1 INNER JOIN
Table1 t2 ON t1.ID = t2.ID
WHERE (t1.name = 'a') AND (t2.name = 'b')
from table1 a,table1 b
where a.id=b.id and a.name<>b.name
group by (a.name+b.name)