/*[sqlquery[*/ SELECT
assessment_attached.assessment_identifier,
assessment_party_role_attached.party_identifier
FROM demo.acme.assessment_result_attached ar
JOIN demo.acme.underwriting_assessment_attached ua ON ar.assessment_result_identifier = ua.assessment_result_identifier
JOIN demo.acme.assessment_attached ON ar.assessment_identifier = assessment_attached.assessment_identifier
JOIN demo.acme.assessment_party_role_attached ON assessment_party_role_attached.assessment_identifier = assessment_attached.assessment_identifier
WHERE assessment_party_role_attached.party_role_code = 'UW'
/*]sqlquery]*/