oracle8.1.6 select * from survey_questions where section_id=(select section_id from survey_sections ss where ss.survey_id=:survey_id) select * from survey_responses where survey_id=:survey_id select * from survey_questions_responses where response_id=:response_id and question_id=:question_id select * from rules where asm_id=:survey_id select * from rules_triggers where rule_id=:rule_id select choice_id from survey_questions_responses where question_id=:qs_id and response_id= (select response_id from survey_responses where survey_id=:survey_id)