0

Please login or register to vote for this query.

(click on this box to dismiss)

Show post history types, post types and vote types.

Q&A for professional and enthusiast programmers

-- Show types
-- Show post history types, post types and vote types.

SELECT TOP 10 *
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 PostHistoryTypes PHT
ON PT.Id = PHT.Id
WHERE COTRT.Id = 4

fork query

edited mar 9 16 Matthew Read

created jun 2 11 Gilles