oracle 8.1.6 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, dotlrn_ecommerce_section dec where ci.item_id = dec.course_id(+) and 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)