i have database following entities:
i have employee entity not shown here has id , name field include in query.
i need create query if given survey id return list of results this:
survey.name | survey.submitter_id | survey.subject_id | question.text | survey_questions.answer_value |survey_questions.anonymous
i can't test query think idea:
select s.name, sq.submitter_id, s.subject_id, q.text, sq.answer_value, sq.anonymous surveys s join survey_questions sq on sq.survey_id = s.id join questions q on sq.question_id = q.id s.id = <your_value>