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