postgresql7.4 select p.instance_name, o.creation_user, o.creation_ip from apm_packages p join acs_objects o on (p.package_id = o.object_id) where p.package_id = :curriculum_id SELECT 1 from cc_curriculum where curriculum_id = :curriculum_id INSERT INTO cc_curriculum (curriculum_id, folder_id, root_keyword_id) VALUES (:curriculum_id, :folder_id, :keyword_id) SELECT cc_curriculum__delete(:curriculum_id) SELECT first_names || ' ' || last_name || ' (' || email || ')' AS name, user_id FROM cc_users SELECT first_names || ' ' || last_name || ' (' || email || ')' AS name, user_id FROM cc_users WHERE user_id NOT IN (SELECT staff_id FROM cc_staff) SELECT s.title || ' ' || u.first_names || ' ' || u.last_name || ' (' || email || ')' AS name, staff_id FROM cc_staff s, cc_users u WHERE s.staff_id = u.user_id SELECT department_name, department_id FROM cc_department WHERE package_id = :package_id