title: How to use Union properly
body: <p>This is my first time using UNION and I'm not sure how to fix this to show the correct output that I want. Currently it is showing me 9 outputs, but I want it to show me just 1 (Randy Troy and his gsExperiencePoints) I want it to get the max from one query and to use a where clause from another for only devName 'Blizzard Entertainment'. Thomas Hardy isn't the correct answer as he doesn't play Blizzard games so he is added because he has the most Exp in any game in my database.</p>
  
  <p><a href="https://i.stack.imgur.com/SD9A6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SD9A6.png" alt=""></a></p>
  
  <p>Currently this is my output: </p>
  
  <p><a href="https://i.stack.imgur.com/JF9Zf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JF9Zf.png" alt=""></a></p>
  
  <p><a href="https://i.stack.imgur.com/FRwQo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FRwQo.png" alt=""></a></p>
  
  <pre><code>SELECT
      gamerFirst + ' ' + gamerLast as 'Gamer',
      gsExperiencePoints
  FROM GAMER as gr
      INNER JOIN GAME_STAT as gs ON gr.gamerID = gs.gamerID
          INNER JOIN GAME as g ON gs.gameID = g.gameID
              INNER JOIN DEVELOPER as d ON g.devID = d.devID
  WHERE gsExperiencePoints = (SELECT MAX(gsExperiencePoints) FROM GAME_STAT)
  GROUP BY gsExperiencePoints, gamerFirst, gamerLast
  UNION ALL
  SELECT
      gamerFirst + ' ' + gamerLast as 'Gamer',
      gsExperiencePoints
  FROM GAMER as gr
      INNER JOIN GAME_STAT as gs ON gr.gamerID = gs.gamerID
          INNER JOIN GAME as g ON gs.gameID = g.gameID
              INNER JOIN DEVELOPER as d ON g.devID = d.devID
  WHERE devName = 'Blizzard Entertainment'
  GROUP BY gsExperiencePoints, gamerFirst, gamerLast;
  </code></pre>