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 u.user_id AS student_id, u.first_names, u.last_name, u.email FROM cc_users u, lrc_lab_student_map m WHERE u.user_id = m.user_id AND m.lab_id = :lab_id