SELECT ques.ques_id, ques.title_2, ques.questions_type, ques.new_order_id, ques.ques_identifier_2, ques.answer_label, ques.assessment_reason, answ.ans_id, answ.question_id, CASE WHEN LEFT(ques.assessment_reason,1) = '1' AND TRIM(IFNULL(ques.questions_2,'')) <> '' THEN ques.questions_2 ELSE ques.questions END AS question_display, CASE WHEN LEFT(ques.assessment_reason,1) = '1' AND TRIM(IFNULL(ques.questions_2,'')) <> '' THEN 1 ELSE 0 END AS show_question_hover, CASE WHEN LEFT(ques.assessment_reason,1) = '1' AND TRIM(IFNULL(answ.answer_2,'')) <> '' THEN answ.answer_2 ELSE answ.answer END AS answer_display FROM #Request.prefix_db_lookup#.assessment_questions_lookup as ques JOIN #Request.prefix_db_lookup#.assessment_answers_lookup as answ ON answ.question_id = ques.ques_id WHERE ques.Deleted = 0 AND answ.Deleted = 0 AND ques.assessment_reason = AND ques.assessment_reason = answ.assessment_reason AND ((ques.answer_label = 'F26' AND LEFT(answ.answer,1) = '1') OR ques.answer_label != 'F26') AND ques.new_wizard != 0 ORDER BY ques.new_wizard, ques.new_order_id, answ.srt_id, ques.answer_label ASC