PostTypes, VoteTypes and PostHistoryTypes in one table

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

select '1. [Post]', NULL, '---' from PostTypes where Id = 1
union
  select '1. [Post]', * from PostTypes
union
  select '2. [Vote]', NULL, '---' from VoteTypes where Id = 1
union
  select '2. [Vote]', * from VoteTypes
union
  select '3. [PostHistory]', NULL, '---' from PostHistoryTypes where Id = 1
union
  select '3. [PostHistory]', * from PostHistoryTypes

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results