SELECT answers.answer, answers.return_value, dependencies.targetid AS target FROM (SELECT * FROM  answers, response_options WHERE answers.id = response_options.answerid AND response_options.questionid = 1) AS answers LEFT JOIN dependencies ON answers.answerid = dependencies.answerid AND dependencies.questionid = 1