title: SQL join on multiple columns in same tables
body: <p>I have 2 subqueries, but I'm having trouble joining columns together from the same tables.  I tried:</p>
  
  <pre><code>SELECT * FROM
  
  (SELECT userid, listid 
  FROM user_views_table
  WHERE date='2013-05-15' AND view_type='lists') a
  
  JOIN
  
  (SELECT sourceid, destinationid
  FROM actions_table
  WHERE date='2013-05-15' AND payloadtype='lists_user' AND actiontype='delete') b
  
  ON a.userid = b.sourceid
  ON a.listid = b.destinationid;
  </code></pre>
  
  <p>If I simply end the query with <code>ON a.userid = b.sourceid</code> it works, but how can I also join these tables on another column also <code>ON a.listid = b.destinationid</code> ?? </p>
  
  <p>Any help appreciated.</p>