postgresql7.4 SELECT faculty_id, faculty_name, (SELECT first_names || ' ' || last_name FROM cc_users WHERE user_id = dean_id) AS dean FROM cc_faculty WHERE package_id = :package_id [template::list::orderby_clause -orderby -name "faculties"]