title: Pivot Queries in a UNION
body: <p>Pivon queries, love em. Turn rows into columns. I need to do a pivot query on the union of 3 other queries. How do I structure this?</p>
  
  <p>I already know the names of the fields in the rows I want to transform but where do I put the pivot statement so it works? </p>