title: Matching two or more column value and display in a single column in SQL server
body: <p>I have two table in SQL Server.
  <strong>tbl_Invoice</strong> as consider bellow<br><br></p>
  
  <p>PayDate ----  Amount<br>
  2017-08-23 |     2300<br>
  2017-08-23 |     2400<br>
  2017-08-23  | 2500<br>
  2017-08-24  | 5000</p>
  
  <p>second Table
  <strong>tbl_Expense</strong> as consider bellow<br><br>
  ExpDate ----     ExpAmount<br>
  2017-08-23  | 1700<br>
  2017-08-25  | 2800<br>
  2017-08-25  | 2900<br></p>
  
  <p>I want to join this two table and display the sum of receipt amount and expense amount of date.
  I want the output to be displayed as bellow</p>
  
  <p>Date   -------      Amount ---   ExpAmount<br>
  2017-08-23 |     7200   |   1700<br>
  2017-08-24  | 5000      | 0<br>
  2017-08-25  | 0         |5700<br></p>