title: MySQL Union Query w/ Left Join - Order By Error?
body: <p>We have a Union Query. Here's a basic (similar) example:</p>
  
  <pre><code>SELECT a.Name, b.Info
  FROM a 
  LEFT JOIN b ON (a.ID = b.ID) 
  WHERE a.Name LIKE "a%"
  UNION
  SELECT a.Name, b.Info 
  FROM a
  LEFT JOIN b ON (a.ID = b.ID)
  WHERE a.Name LIKE "b%"
  ORDER BY a.Name, b.Info;
  </code></pre>
  
  <p>I am receiving an error that says "Unknown column 'b.Info' in 'order clause'".</p>
  
  <p>When I remove the "b.Info" from the end of the ORDER BY clause, it works.</p>
  
  <p>Ideas ?</p>