postgresql7.4 SELECT s.stream_id, s.stream_name, s.stream_code, (SELECT d.department_name FROM cc_department d WHERE d.department_id = s.department_id) as department FROM cc_stream s WHERE package_id = :package_id AND s.coordinator_id = :user_id [template::list::orderby_clause -orderby -name "streams"]