SELECT b.question_id, b.question_code, b.question_type, tl.user_question_name from msc_questions_tl tl, msc_questions_b b WHERE b.question_id = tl.question_id and tl.language = userenv('LANG')
View Text - HTML Formatted
SELECT B.QUESTION_ID , B.QUESTION_CODE , B.QUESTION_TYPE , TL.USER_QUESTION_NAME FROM MSC_QUESTIONS_TL TL , MSC_QUESTIONS_B B WHERE B.QUESTION_ID = TL.QUESTION_ID AND TL.LANGUAGE = USERENV('LANG')