postgresql7.4 SELECT name, description, person__name(instructor_id) AS instructor, instructor_id, to_char(start_date, 'DD Month, YYYY') AS start_date, to_char(end_date, 'DD Month, YYYY') AS end_date FROM lrc_lab WHERE lab_id = :lab_id SELECT t.template_id, t.name AS template_name, t.description AS template_desc, to_char(m.start_date, 'DD Month, YYYY') AS release_date, to_char(m.end_date, 'DD Month, YYYY') AS submission_date FROM lrc_template t, lrc_lab_template_map m WHERE m.lab_id = :lab_id AND m.template_id = t.template_id AND t.package_id = :package_id ORDER BY m.end_date ASC SELECT u.user_id AS student_id, u.first_names, u.last_name, u.email, gs.group_name FROM cc_users u, lrc_marker_group_map g, group_member_map m, groups gs WHERE u.user_id = m.member_id AND g.lab_id = :lab_id AND g.marker_id = :user_id AND g.group_id = m.group_id AND gs.group_id = g.group_id