Don't touch my junk.

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results