title: How to join 2 queries
body: <p>I have 2 SQL queries:  </p>
  
  <pre><code>SELECT accounts.assigned_user_id, jt0.user_name assigned_user_name,
  SUM( IF(opp.opportunity_type='2', IFNULL(opp.amount,0), 0) ) AS amt_revenue,
  SUM( IF(opp.opportunity_type='4', IFNULL(opp.amount,0), 0) ) AS amt_return
  FROM accounts
  LEFT JOIN users jt0
  ON jt0.id=accounts.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0
  LEFT JOIN accounts_opportunities AS a_o
  ON a_o.account_id = accounts.id AND a_o.deleted=0
  LEFT JOIN opportunities AS opp
  ON (opp.id = a_o.opportunity_id AND opp.deleted=0 AND opp.sales_stage = 'Closed Won' AND opp.opportunity_type IN('2', '4'))
  WHERE accounts.deleted=0
  GROUP BY accounts.assigned_user_id, jt0.user_name
  ORDER BY SUM(IFNULL(opp.amount,0)) DESC
  </code></pre>
  
  <p>And:</p>
  
  <pre><code>SELECT accounts.assigned_user_id, 
  SUM( IFNULL(accounts_collections.amount,0)) AS amount 
  FROM accounts 
  LEFT JOIN accounts_collections ON(accounts_collections.account_id = accounts.id AND accounts_collections.deleted=0) 
  GROUP BY accounts.assigned_user_id
  </code></pre>
  
  <p>How can I join the 2 queries above?</p>