mysql - How would I use a SQL query for the following result -


i have database following entities: survey model

question model

survey question

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>