postgresql7.4
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
SELECT map.map_id, n.uos_code, n.uos_name, uos.uos_id,
rev.year_id, y.name, rev.core_id,
map.live_revision_id, uosr.session_ids, uos.uos_name_id,
rel.name AS rel_name, dr.learning_outcomes, dr.objectives,
dr.syllabus
FROM cc_uos uos, cc_uos_revisions uosr, cc_stream_uos_map map,
cc_stream_uos_map_rev rev, cc_year y, cc_uos_name n,
cc_stream_uos_rel rel, cc_uos_detail_revisions dr, cc_uos_detail d
WHERE uos.uos_id = map.uos_id
AND map.stream_id = :stream_id
AND map.live_revision_id = rev.map_rev_id
AND rev.year_id = y.year_id
AND rev.year_id != 0
AND uos.live_revision_id = uosr.uos_revision_id
AND n.name_id = uos.uos_name_id
AND rev.core_id = rel.stream_uos_rel_id
AND dr.detail_revision_id = d.live_revision_id
AND d.parent_uos_id = uos.uos_id
SELECT cc_session__name(:session_id)
SELECT DISTINCT gan.name, ga.level, ga.description
FROM cc_uos_gradattr_set gas, cc_uos_gradattr_map gam,
cc_uos_gradattr_name gan, cc_uos_gradattr ga
WHERE gas.parent_uos_id = :uos_id
AND gas.live_revision_id = gam.revision_id
AND gam.gradattr_id = ga.gradattr_id
AND ga.name_id = gan.name_id