title: SQL Join two query having different number of columns
body: <p><strong>First Query</strong>:(I have added count(*) for simplification)</p>
  
  <pre><code>select count(*) from Sales_order_line sol
  where
  sol.grant_type_id is null
  AND
   sol.quantity  - NVL ((SELECT SUM (salesorder15_.assigned_quantity) FROM license_link_sales_ord_ln salesorder15_  
   WHERE salesorder15_.sales_order_line_id = sol.ID),0) &gt; 0;
  </code></pre>
  
  <p><strong>Second Query</strong>:(I have added count(*) for simplification)</p>
  
  <pre><code>select count(*) from Sales_order_line sol
  INNER JOIN license_link_sales_ord_ln sola
  ON sol.id=sola.sales_order_line_id
  where
  sol.grant_type_id is null;
  </code></pre>
  
  <p>The first query returns <strong>56119</strong> and second one returns <strong>362260</strong>. I want to combine the queries which gives me <strong>(56119 +362260)</strong> as result.</p>