Show all values in known tables that map a type id to a type name.
Q&A for professional and enthusiast programmers
-- Show types -- Show post history types, post types and vote types. SELECT Coalesce(COTRT.Id, CRT.Id, FT.Id, PT.Id, PHT.Id, RTRT.Id, RTT.Id, VT.Id) As [Id], PT.Name As [Post], PHT.Name As [Revision], VT.Name As [Vote], CRT.Name As [Close], COTRT.MarkdownMini As [Off-topic], FT.Name As [Flag], RTT.Name As [Review], RTRT.Name As [Review result] FROM PostTypes PT LEFT JOIN CloseAsOffTopicReasonTypes COTRT ON COTRT.Id = PT.Id LEFT JOIN CloseReasonTypes CRT ON CRT.Id = PT.Id LEFT JOIN FlagTypes FT ON FT.Id = PT.Id LEFT JOIN PostHistoryTypes PHT ON PHT.Id = PT.Id LEFT JOIN VoteTypes VT ON VT.Id = PT.Id LEFT JOIN ReviewTaskResultTypes RTRT ON RTRT.Id = PT.Id LEFT JOIN ReviewTaskTypes RTT ON RTT.Id = PT.Id ORDER BY Id ASC