postgresql7.4 SELECT * FROM cc_stream WHERE package_id = :package_id LIMIT 1 SELECT name, year_id FROM cc_year WHERE package_id = :package_id SELECT name, semester_id FROM cc_semester WHERE package_id = :package_id SELECT year_ids FROM cc_stream WHERE stream_id = :stream_id SELECT name FROM cc_year WHERE year_id = :year_id SELECT semester_ids FROM cc_stream WHERE stream_id = :stream_id SELECT name from cc_semester WHERE semester_id = :semester_id SELECT uos_code || ' ' || uos_name as name, uos_id FROM cc_uos WHERE package_id = :package_id AND uos_id != :except_uos_id SELECT uos.uos_code || ' ' ||uos.uos_name AS name, uos.uos_id FROM cc_uos uos WHERE uos.package_id = :package_id