/*[sqlquery[*/ SELECT
assessment_attached.assessment_identifier,
assessment_description,
assessment_attached.begin_date,
assessment_attached.end_date,
assessment_result_type_code
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
/*]sqlquery]*/