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