/*[sqlquery[*/ SELECT CAST(assessment.assessment_identifier as VARCHAR) as assessment_identifier, CAST(assessment_description as VARCHAR) as assessment_description, CAST(assessment.begin_date as VARCHAR) as begin_date, CAST(assessment.end_date as VARCHAR) as end_date, CAST(assessment_result_type_code as VARCHAR) as assessment_result_type_code
FROM demo.acme.assessment_result ar
JOIN demo.acme.underwriting_assessment ua on ar.assessment_result_identifier = ua.assessment_result_identifier
JOIN demo.acme.assessment on ar.assessment_identifier = assessment.assessment_identifier
/*]sqlquery]*/