Index: openacs-4/packages/curriculum-central/www/stream-map-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/stream-map-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/curriculum-central/www/stream-map-postgresql.xql 2 Feb 2006 11:52:15 -0000 1.1 +++ openacs-4/packages/curriculum-central/www/stream-map-postgresql.xql 13 Feb 2006 01:30:07 -0000 1.2 @@ -5,12 +5,13 @@ - SELECT f.faculty_id, f.faculty_name, d.department_id, d.department_name - FROM cc_faculty f, cc_department d, cc_stream s - WHERE f.faculty_id = d.faculty_id - AND d.department_id = s.department_id - AND s.stream_id = :stream_id - AND s.package_id = :package_id + SELECT f.faculty_id, f.faculty_name, d.department_id, d.department_name, + s.stream_name + FROM cc_faculty f, cc_department d, cc_stream s + WHERE f.faculty_id = d.faculty_id + AND d.department_id = s.department_id + AND s.stream_id = :stream_id + AND s.package_id = :package_id