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