Show all values in known tables that map a type id to a type name.
Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
-- Show types -- Show all values in known tables that map a type id to a type name. SELECT Coalesce(COTRT.Id, CRT.Id, FT.Id, PT.Id, PHT.Id, PNT.Id, RTRT.Id, RTT.Id, VT.Id) As [Id], Min(PT.Name) As [Post], Min(PHT.Name) As [Revision], Min(PNT.Name) As [Notice], Min(VT.Name) As [Vote], Min(CRT.Name) As [Close], Min(COTRT.MarkdownInputGuidance) As [Off-topic], Min(FT.Name) As [Flag], Min(RTT.Name) As [Review], Min(RTRT.Name) As [Review result] FROM PostTypes PT FULL OUTER JOIN CloseAsOffTopicReasonTypes COTRT ON PT.Id = COTRT.Id FULL OUTER JOIN CloseReasonTypes CRT ON PT.Id = CRT.Id FULL OUTER JOIN FlagTypes FT ON PT.Id = FT.Id FULL OUTER JOIN PostHistoryTypes PHT ON PT.Id = PHT.Id FULL OUTER JOIN PostNoticeTypes PNT ON PT.Id = PNT.Id FULL OUTER JOIN VoteTypes VT ON PT.Id = VT.Id FULL OUTER JOIN ReviewTaskResultTypes RTRT ON PT.Id = RTRT.Id FULL OUTER JOIN ReviewTaskTypes RTT ON PT.Id = RTT.Id GROUP BY Coalesce(COTRT.Id, CRT.Id, FT.Id, PT.Id, PHT.Id, PNT.Id, RTRT.Id, RTT.Id, VT.Id) ORDER BY Id ASC