title: Multiple select statements in one, creating new columns
body: <p>I have searched everywhere and I can't seem to find the solution. </p>
  
  <p>now I know the function of <strong>UNION</strong>, but I'm not sure if it is used here correctly. Here is my query:</p>
  
  <pre><code>  SELECT pos.pdPosition AS [Region 1]  
    FROM PositionData pos 
    WHERE pos.PositionId = 1765
    UNION ALL 
    SELECT pos.pdPosition AS [Region 2] 
    FROM PositionData pos 
    WHERE pos.PositionId = 1767
  </code></pre>
  
  <p><strong>What I want</strong> is for it to create the new columns, Region 1 containing number 1's data and Region 2 containing number 2's data.</p>
  
  <p><strong>What I'm getting</strong> is this:</p>
  
  <p><img src="https://i.stack.imgur.com/AG6MD.png" alt="enter image description here"></p>
  
  <p>How can I split it up/what statement can I use?</p>
  
  <p><strong>NOTE:</strong> This has to be a select statement.</p>