title: The Inner Join is returning result from only one table instead of both tables
body: <pre><code>SELECT InvoiceNo as [Invoice No],
         SUM(Quantity) as Quantity,
         SUM(TaxableAmt) as Taxable_Amount,
         SUM(CGSTAmt) as CGST_Amount,
         SUM(SGSTAmt) as SGST_Amount,
         SUM(Amount) as Amount 
  FROM tbl_PurchaseDetails    
  INNER JOIN tbl_CUSTOMERMASTER 
    ON tbl_CUSTOMERMASTER.PartyID = tbl_PurchaseDetails.PartyID     
  GROUP BY tbl_PurchaseDetails.InvoiceNo
  </code></pre>
  
  <p>The above query is returning result from only one table while I want result from both tables.</p>
  
  <p>It is displaying result like this: </p>
  
  <p><a href="https://i.stack.imgur.com/QVXCp.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QVXCp.jpg" alt="enter image description here"></a></p>
  
  <p>While I want my result like this: </p>
  
  <p><a href="https://i.stack.imgur.com/agQVL.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/agQVL.jpg" alt="enter image description here"></a></p>