Is there a way to do this? Im trying to LEFT JOIN to a table that needs to select based on 2 keys, but the query Im writing only has the keys individually in two separate tables, like this. The documentation shows how to do this when you are using 2 keys from both tables, but not 1 key from 1 table and another key from another table combined. http://www.mysql.com/doc/en/JOIN.html
SELECT
FROM
t1,
INNER JOIN t2 on (c1)
INNER JOIN t3 on (c2)
LEFT JOIN t4 on (c1,c2)
Thanks!
