postgresql7.1 SELECT r.item_id as assessment_id, s.session_id, s.percent_score, to_char(s.completed_datetime, :format) as completed_datetime, p.first_names || ' ' || p.last_name AS subject_name, r.title AS assessment_name, s.subject_id FROM as_sessions s, cr_revisions r, persons p WHERE s.assessment_id = r.revision_id AND s.subject_id = p.person_id AND s.subject_id = :subject_id AND r.item_id = :assessment_id ORDER BY s.completed_datetime desc, s.creation_datetime desc SELECT r.item_id as assessment_id, s.session_id, s.percent_score, to_char(s.completed_datetime, :format) as completed_datetime, p.first_names || ' ' || p.last_name AS subject_name, r.title AS assessment_name, s.subject_id FROM as_sessions s, cr_revisions r, persons p WHERE s.assessment_id = r.revision_id AND s.subject_id = p.person_id AND r.item_id = :assessment_id ORDER BY s.completed_datetime desc, s.creation_datetime desc