title: MySQL UNION - combining the returned values into one set of rows
body: <p>I am new to MySQL and need to ask for your help please.
  I am selecting 2 sets of count values from the same table in 2 parts of a union using different WHERE clause values to differentiate; like this:</p>
  
  <pre><code>SELECT Count(column1) as 'RED', null as 'BLUE'
  FROM TableA
  Where column1 Like 'RED'
  UNION
  SELECT NULL, Count(column1)
  FROM TableA
  Where column1 Like 'BLUE'
  </code></pre>
  
  <p>I was hoping to get:</p>
  
  <pre><code>RED      BLUE
  ---      ----
  23       55
  </code></pre>
  
  <p>But what I actually get is:</p>
  
  <pre><code>RED      BLUE
  ---      ----
  23       NULL
  NULL     55
  </code></pre>
  
  <p>Can anyone please tell me what I've done wrong and how I can get my desired answer please?
  Thanks for your help...</p>