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,
(SELECT first_names || ' ' || last_name
FROM cc_users
WHERE user_id = s.coordinator_id) AS stream_coordinator
FROM cc_stream s
WHERE package_id = :package_id
[template::list::orderby_clause -orderby -name "streams"]