title: Find out total day sale based on same day
body: <p>I have following data in my Sale table:</p>
  
  <pre><code>   Staff_Code  | Tran_Date  |  Morning_Sale | Night_Sale | Total_Sale
         S01     | 2013-05-01 |     50.00     |   300.00   |  350.00
         S02     | 2013-05-01 |     10.00     |   70.00    |   80.00
         S01     | 2013-05-02 |     100.00    |   20.00    |  120.00
  </code></pre>
  
  <p>I want to add 1 more column "total_Day_Sale" to know the daily total sale,the format as following table:</p>
  
  <pre><code>   Staff_Code  | Tran_Date  |  Morning_Sale | Night_Sale | Total_Sale | Total_Day_Sale
         S01     | 2013-05-01 |     50.00     |   300.00   |  350.00    |   430.00  
         S02     | 2013-05-01 |     10.00     |   70.00    |   80.00    |   430.00
         S01     | 2013-05-02 |     100.00    |   20.00    |  120.00    |   120.00
  </code></pre>
  
  <p>I was trying the following code but not as result I expected!</p>
  
  <pre><code>SELECT Tran_Date,Morning_Sale,Night_Sale,Morning_Sale + Night_Sale As 'Total_Sale', 
  sum(Morning_Sale)+sum(Night_Sale ) As 'Total_Day_Sale' FROM Sale 
  WHERE Tran_Date=Tran_Date  
  </code></pre>
  
  <p>Is it possible to do that? Thanks</p>