SELECT Name
FROM Tags
GROUP BY Name
HAVING SUM(CASE WHEN TagId = 1 THEN 1 ELSE 0 END) > 0
   AND SUM(CASE WHEN TagId = 2 THEN 1 ELSE 0 END) = 0;