oracle8.1.6 select sq.question_id as qs_id, sq.question_text as description from survey_questions sq where sq.section_id in (select section_id from survey_sections where survey_id = (select asm_id as survey_id from rules where rule_id=:rule_id)) and sq.question_id not in (select qs_id from rules_triggers where rule_id=:rule_id) and (select count(choice_id) from survey_question_choices where question_id = sq.question_id) > 0 select choice_id as result_id, label as value from survey_question_choices where question_id = :selected_qs