postgresql 7.1 select dc.course_id, dc.course_key, dc.course_name, dc.assessment_id, dec.section_id, dec.section_name, dec.product_id, dec.community_id, dc.course_info, ci.item_id from dotlrn_catalog dc, cr_items ci left join dotlrn_ecommerce_section dec on (ci.item_id = dec.course_id) where dc.course_id = ci.live_revision [template::list::filter_where_clauses -and -name course_list] order by lower(dc.course_name), lower(dec.section_name)