Query to get question and Answers

Summary

Query to get question and Answers

Content

Hi Experts,

I am trying to build a  query which gives questions and answers for End Year PD. I am using below tables to get question and answers.

HRQ_QUESTIONS_TL          

HRQ_ALL_QSTN_ANSWERS_V

But i am got getting answers, It's showing empty.

Below is my basic query.

SELECT    HRT.QUESTION_TEXT,

          HQAV.LONG_TEXT,

  HQAV.SHORT_TEXT

 

FROM      HRQ_QUESTIONS_TL          HRT,

          HRQ_ALL_QSTN_ANSWERS_V       HQAV

          

 

WHERE   HRT.QUESTION_ID=HQAV.QUESTION_ID(+)

AND     HRT.QUESTION_ID IN ('300000015153102')

Version

20A