title: MySQL Union of tables with different amount of rows
body: <p><a href="https://i.stack.imgur.com/ejbqR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ejbqR.png" alt="Example" /></a></p>
  <p>The picture above shows the result I need. I am not sure how to combine the tables when there needs to be a different amount of rows showing across. I don't know if having a different amount of rows like in the picture matters in the sense that I have to change anything. Also, I am not sure if I did the subtotal part right.</p>
  <pre><code>SELECT Invoice.InvoiceNo, Invoice.Invoice_Date, 
  Invoice.Invoice_Time, Employee.Employee_Name, Invoice.TotalAmount 
  FROM Invoice INNER JOIN Employee ON 
  Invoice.Employee_ID=Employee.EmployeeID WHERE InvoiceNo=109
  UNION
  SELECT Item_ID, Price, Quantity, SUM(Price) As Subtotal 
  FROM InvoiceItem WHERE Invoice_No2=109;
  </code></pre>