title: Retrieve data from 3 tables in SQL Server
body: <p>Query </p>
  
  <pre><code>SELECT     
      dbo.SI_Customer.cst_Name, dbo.SI_InvoiceMaster.invcm_DocNo,    
      dbo.SI_InvoiceMaster.invcm_Date, dbo.SI_InvoiceMaster.invcm_TotalAmount, 
      dbo.SI_ReceiptMaster.recm_DocNo, dbo.SI_ReceiptMaster.recm_Date,    
      dbo.SI_ReceiptMaster.recm_TotalAmount
  FROM         
      dbo.SI_Customer 
  FULL OUTER JOIN
      dbo.SI_ReceiptMaster ON dbo.SI_Customer.cst_Code = dbo.SI_ReceiptMaster.cst_Code 
  FULL OUTER JOIN
      dbo.SI_InvoiceMaster ON dbo.SI_Customer.cst_Code = dbo.SI_InvoiceMaster.cst_Code
  WHERE     
      (dbo.SI_Customer.cst_Code = '001813')
  </code></pre>
  
  <p>Below is the result from this query - I don't want to repeat these values</p>
  
  <p><img src="https://i.stack.imgur.com/HHw80.jpg" alt="enter image description here"></p>