EHS:Multiple Participants on Single Incident

Summary

EHS:Multiple Participants on Single Incident

Content

Hi Team,

For a single incident we are having multiple participant. So I want to know some joining condition which helps me to find correct participant and answer of question.

Below is the SQL

Select R.ANSWER_CLOB
        From HRQ_QSTNR_PARTICIPANTS P
            , HRQ_QSTN_RESPONSES R
            , HRQ_QSTNR_RESPONSES Q
            ,HRQ_QSTNR_QUESTIONS  questns
            ,HRQ_QSTNR_SECTIONS_VL secb
            ,HRQ_QUESTIONNAIRES_VL qb
            ,HNS_INCIDENTS_SUMMARY HIS
        Where Q.qstnr_participant_id = P.qstnr_participant_id
        and R.qstnr_response_id = Q.qstnr_response_id
        and p.QUESTIONNAIRE_ID=qb.QUESTIONNAIRE_ID