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