81,092
社区成员
发帖
与我相关
我的任务
分享
FROM
info2 info
LEFT OUTER JOIN question_list ql
ON info.enq_no = ql.enq_no
LEFT OUTER JOIN choice_list cl
ON info.enq_no = cl.enq_no
AND ql.question_no = cl.question_no
from info2,question_list,choice_list
where
info.enq_no = ql.enq_no(+)
and info.enq_no = cl.enq_no(+)
AND ql.question_no = cl.question_no(+)
SELECT
FI.SVCID,
FI.GROUPNO,
FI.ENQUETENO,
QL.QUESTIONNO,
QL.QUESTION,
QL.QTYPE,
CL.CHOICENO,
CL.CHOICETXT,
FI.STARTDT,
FI.ENDDT
FROM
ENQFORMINFO2 FI ,ENQQUESTIONLST2 QL,ENQCHOICELST2 CL
WHERE
FI.SVCID = 'XXX'
AND
FI.GROUPNO = 46
AND
FI.STARTDT < SYSDATE
AND
FI.ENDDT > SYSDATE
AND FI.ENQUETENO = QL.ENQUETENO(+)
AND FI.ENQUETENO = CL.ENQUETENO(+)
AND QL.QUESTIONNO = CL.QUESTIONNO(+)