Q&A for speakers of other languages learning English
SELECT IsNUll(TargetTagName, TagName) AS MainTag , TagName as TagName , Tags.Id as TagId FROM Tags LEFT JOIN TagSynonyms ON SourceTagName=TagName