0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

SELECT IsNull(Main.TagName, Alias.TagName) AS MainName
         , IsNull(Main.Id,      Alias.Id     ) AS MainId
         , Alias.TagName as AliasName
         , Alias.Id as AliasId
        FROM Tags as Alias
        LEFT JOIN TagSynonyms 
                ON SourceTagName=Alias.TagName
        LEFT JOIN Tags as Main
                ON TargetTagName=Main.TagName

view current version

edited jan 17 14

created jan 17 14 rolfl