I want to get values out of a group of tables but want to get null values in 2 instances if either join doesn't match on one table. I don't know the correct syntax in whic to write the query.
Here's the basic idea:
LEFT JOIN au_key_content on au_key_content.input_content_id=au_input_content.input_content_id
WHERE au_row.content_id=#content# AND au_row.content_id=au_input_content.content_id
order by au_row.row_id
Of course this doesn't work because you can't write the join this way referencing two different databases in the same join statement. How would I write this to work so that au_key_content is joined conditionally on both tables? I want to get Null values for the keys if either join fails.