oracle8.1.6 select $column_name as response, person.name(o.creation_user) as respondent_name, o.creation_date as submission_date, o.creation_user, o.creation_ip as ip_address from survey_responses r, survey_question_responses qr, acs_objects o where qr.response_id = r.response_id and qr.question_id = :question_id and o.object_id = qr.response_id order by submission_date