oracle8.1.6 select response_id, case when initial_response_id is NULL then 'T' else 'F' e\ nd as original_p, nvl(initial_response_id,response_id) as initial_response, creatio\ n_date from survey_responses, acs_objects where response_id = object_id and survey_response.initial_user_id(response_id) = :user_id and survey_id=:survey_id order by nvl(initial_response_id,response_id) desc, creation_date desc