postgresql7.4
SELECT l.lab_id, l.name AS lab_name, l.instructor_id,
to_char(l.start_date, 'YYYY') AS year
FROM lrc_lab l, lrc_lab_student_map s
WHERE s.lab_id = l.lab_id
AND l.lab_id = :lab_id
AND s.user_id = :author_id
SELECT t.template_id, t.name,
t.description AS template_desc
FROM lrc_template t, lrc_lab_template_map m
WHERE m.lab_id = :lab_id
AND m.template_id = t.template_id