title: Join two MYSQL WHERE queries together
body: <p>I would like to join the result of 2 queries together so that I end up with 3 columns, first column being the MONTH, second column being WITHDRAWALS and third being DEPOSITS.</p>
  
  <p><strong>Query 1:</strong></p>
  
  <pre><code>SELECT
      DATE_FORMAT(Time, "%m-%Y") AS MONTH,
      SUM(Profit_Loss) AS DEPOSITS
  FROM
      `deposits_withdrawals_view`
  WHERE
      Summary = 'Cash In'
  GROUP BY
      DATE_FORMAT(Time, "%m-%Y")
  </code></pre>
  
  <p><strong>Query 2:</strong></p>
  
  <pre><code>SELECT
      DATE_FORMAT(Time, "%m-%Y") AS MONTH,
      SUM(Profit_Loss) AS WITHDRAWALS
  FROM
      `deposits_withdrawals_view`
  WHERE
      Summary = 'Cash Out'
  GROUP BY
      DATE_FORMAT(Time, "%m-%Y")
  </code></pre>
  
  <p>Both work individually but how to I join them together in 1 query?</p>
  
  <p>Thanks for your help.</p>