postgresql7.1 SELECT as_sessionsx.session_id, as_sessionsx.name, as_sessionsx.title, persons.first_names, persons.last_name FROM as_sessions WHERE as_sessionsx.assessment_id=:assessment_id AND as_sessions.subject_id = persons.person_id