title: The number of columns in the two selected tables or queries of a Union query do not match
body: <p>I have been facing error in MS Access  and error is <strong>"The number of columns in the two selected tables or queries of a Union query do not match."</strong> </p>
  
  <p>Here is my SQL query:</p>
  
  <pre><code>SELECT sale_head.suppliername AS sale_head_suppliername,
  sale_head.invoiceno AS sale_head_invoiceno, sale_head.invoicedate,
  sale_details.invoiceno AS sale_details_invoiceno, sale_details.suppliername AS       sale_details_suppliername,
  sale_details.product_code, sale_details.qty, sale_details.totalkg, sale_details.Rate,   sale_details.subtotal FROM sale_head 
  
  INNER JOIN sale_details ON sale_head.[invoiceno] = sale_details.[invoiceno] 
  UNION ALL select 'Total', sum(sale_details.subtotal) from sale_details
  
  WHERE (((sale_head.suppliername)='Ramkrishna Creation'));
  </code></pre>
  
  <p>Am I missing something ? If yes please do let me know.</p>