oracle8.1.6 select s.survey_id, s.name, s.editable_p, s.single_response_p, sr.response_id, to_char(sr.creation_date,'Month FMDD, YYYY') as creation_date from surveys s ,(select survey_id, response_id, creation_date from survey_responses_latest where initial_user_id = :user_id) sr where s.package_id=:package_id and s.survey_id = sr.survey_id(+) and s.enabled_p='t' order by upper(s.name)