postgresql7.1
SELECT as_assessmentsx.assessment_id, as_assessmentsx.name, as_assessmentsx.title, as_assessmentsx.description
FROM as_assessments
SELECT assessment_id, as_sections.section_id, as_sections.name, as_sections.definition
FROM as_sections JOIN as_assessment_section_map
ON (as_sections.section_id=as_assessment_section_map.section_id)
WHERE assessment_id=2