title: Combining the results from two separate queries in to two columns
body: <p>I am  working with two sql queries that I would like to combine as one so the result of the first query would be in the first column and the result of the second one in column two.  How can I acheive this?</p>
  
  <p>I tried union, but it will put the results in two rows.. thats not what I want... </p>
  
  <pre><code>select count(*) as ColumnA from Inventory i, Sale s where i.vin=s.vin and i.condition='new' 
  
  select count(*) as ColumnB from Inventory i, Sale s where i.vin=s.vin and i.condition='used' order by 1 desc;
  </code></pre>