Q&A for amateur radio enthusiasts
SELECT TargetTagName AS MainTag , TagName as TagName , Tags.Id as TagId FROM Tags LEFT JOIN TagSynonyms ON SourceTagName=TagName