SQL join in multiple columns in the same tables

Question

I have 2 subqueries, but I am unable to combine columns from the same tables. I tried:

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; 

If I just end the query with ON a.userid = b.sourceid , it works, but how can I also join these tables in another column also ON a.listid = b.destinationid ?

Any help was appreciated.

Answer 1

Join this:

 ON a.userid = b.sourceid AND a.listid = b.destinationid; 

Answer 2

You want to join condition 1 and condition 2, so just use the ID keyword below

 ON a.userid = b.sourceid AND a.listid = b.destinationid;