17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT
FI.SVCID,
FI.GROUPNO,
FI.ENQUETE_NO,
QL.QUESTION_NO,
QL.QUESTION,
QL.QTYPE,
CL.CHOICENO,
CL.CHOICETXT,
FI.STARTDT,
FI.ENDDT
FROM
INFO FI
LEFT OUTER JOIN QUESTION_LIST QL
ON FI.ENQUETE_NO = QL.ENQUETE_NO
LEFT OUTER JOIN CHOICE_LIST CL
ON FI.ENQUETE_NO = CL.ENQUETE_NO
AND QL.QUESTION_NO = CL.QUESTION_NO
WHERE
FI.SVCID = 'XXX'
AND
FI.GROUPNO = 53
AND
FI.STARTDT < SYSDATE
AND
FI.ENDDT > SYSDATE
第一步
select * from a,b where a.id=b.id(+)
OK
第二步
select * from a,b,c where a.id=b.id(+) and a.id=c.id(+)
select FICL.SVCID, FICL.GROUPNO, FICL.ENQUETE_NO, FICL.STARTDT, FICL.ENDDT , FICL.CHOICENO, FICL.CHOICETXT,FICL.QUESTION_NO, QL.QUESTION_NO, QL.QUESTION, QL.QTYPE
from
(
SELECT FI.SVCID, FI.GROUPNO, FI.ENQUETE_NO, FI.STARTDT, FI.ENDDT , CL.CHOICENO, CL.CHOICETXT,CL.QUESTION_NO
from INFO FI ,CHOICE_LIST CL
where FI.ENQUETE_NO = CL.ENQUETE_NO(+) and FI.SVCID = 'XXX' AND FI.GROUPNO = 53 AND FI.STARTDT < SYSDATE AND FI.ENDDT > SYSDATE ) FICL,
QUESTION_LIST QL
where FICL.ENQUETE_NO= QL.ENQUETE_NO(+) and FICL.QUESTION_NO=QL.QUESTION_NO(+)
select FICL.SVCID, FICL.GROUPNO, FICL.ENQUETE_NO, FICL.STARTDT, FICL.ENDDT , FICL.CHOICENO, FICL.CHOICETXT,FICL.QUESTION_NO
from
(
SELECT FI.SVCID, FI.GROUPNO, FI.ENQUETE_NO, FI.STARTDT, FI.ENDDT , CL.CHOICENO, CL.CHOICETXT,CL.QUESTION_NO
from INFO FI ,CHOICE_LIST CL
where FI.ENQUETE_NO = CL.ENQUETE_NO(+) and FI.SVCID = 'XXX' AND FI.GROUPNO = 53 AND FI.STARTDT < SYSDATE AND FI.ENDDT > SYSDATE ) FICL,
QUESTION_LIST QL
where FICL.ENQUETE_NO= QL.ENQUETE_NO(+) and FICL.QUESTION_NO=QL.QUESTION_NO(+)
SELECT FI.SVCID, FI.GROUPNO, FI.ENQUETE_NO, QL.QUESTION_NO, QL.QUESTION, QL.QTYPE, CL.CHOICENO, CL.CHOICETXT, FI.STARTDT, FI.ENDDT
FROM INFO FI , QUESTION_LIST QL ,CHOICE_LIST CL
WHERE FI.ENQUETE_NO *= QL.ENQUETE_NO AND FI.ENQUETE_NO *= CL.ENQUETE_NO AND CL.QUESTION_NO *=QL.QUESTION_NO
FI.SVCID = 'XXX' AND FI.GROUPNO = 53 AND FI.STARTDT < SYSDATE AND FI.ENDDT > SYSDATE
SELECT FI.SVCID, FI.GROUPNO, FI.ENQUETE_NO, QL.QUESTION_NO, QL.QUESTION, QL.QTYPE, CL.CHOICENO, CL.CHOICETXT, FI.STARTDT, FI.ENDDT
FROM INFO FI , QUESTION_LIST QL ,CHOICE_LIST CL
WHERE FI.ENQUETE_NO = QL.ENQUETE_NO(+) AND FI.ENQUETE_NO = CL.ENQUETE_NO(+) AND CL.QUESTION_NO=QL.QUESTION_NO(+)
FI.SVCID = 'XXX' AND FI.GROUPNO = 53 AND FI.STARTDT < SYSDATE AND FI.ENDDT > SYSDATE
SELECT
FI.SVCID,
FI.GROUPNO,
FI.ENQUETE_NO,
QL.QUESTION_NO,
QL.QUESTION,
QL.QTYPE,
CL.CHOICENO,
CL.CHOICETXT,
FI.STARTDT,
FI.ENDDT
FROM
INFO FI
,QUESTION_LIST QL
,CHOICE_LIST CL
WHERE
FI.ENQUETE_NO = QL.ENQUETE_NO(+)
AND
FI.ENQUETE_NO = CL.ENQUETE_NO(+)
AND
CL.QUESTION_NO = QL.QUESTION_NO(+)
AND
FI.SVCID = 'XXX'
AND
FI.GROUPNO = 53
AND
FI.STARTDT < SYSDATE
AND
FI.ENDDT > SYSDATE
SELECT
FI.SVCID,
FI.GROUPNO,
FI.ENQUETE_NO,
QL.QUESTION_NO,
QL.QUESTION,
QL.QTYPE,
CL.CHOICENO,
CL.CHOICETXT,
FI.STARTDT,
FI.ENDDT
FROM
INFO FI
,QUESTION_LIST QL
,CHOICE_LIST CL
WHERE
FI.ENQUETE_NO = QL.ENQUETE_NO(+)
AND
FI.ENQUETE_NO = CL.ENQUETE_NO(+)
AND
QL.QUESTION_NO = CL.QUESTION_NO(+)
AND
FI.SVCID = 'XXX'
AND
FI.GROUPNO = 53
AND
FI.STARTDT < SYSDATE
AND
FI.ENDDT > SYSDATE
SELECT
FI.SVCID, FI.GROUPNO, FI.ENQUETE_NO, QL.QUESTION_NO,
QL.QUESTION, QL.QTYPE, CL.CHOICENO, CL.CHOICETXT,
FI.STARTDT, FI.ENDDT
FROM INFO FI, QUESTION_LIST QL, CHOICE_LIST CL
WHERE FI.ENQUETE_NO = QL.QL.ENQUETE_NO(+)
AND FI.ENQUETE_NO = CL.ENQUETE_NO(+)
AND FI.SVCID = 'XXX'
AND FI.GROUPNO = 53
AND FI.STARTDT < SYSDATE
AND FI.ENDDT > SYSDATE;