patrick118
Technical User
I have an rather large SQL statement and want to build a report with the same comditions. I do it with the select expert option and then try to make it the same. This is the statement. Now the problem lies in the point that i don't know how to do the select statement in the report.
WHERE A.AFWIJKING_ID=B.AFWIJKING_ID (+)
AND B.C_SRT_AFWIJKING=C.C_SRT_AFWIJKING (+) AND A.C_VERWEZEN_NAAR=D.C_VERWEZEN_NAAR
(+) AND A.C_SRT_AKTIE=E.C_SRT_AKTIE (+) AND A.CLIENT_ID=F.CLIENT_ID (+)
AND A.C_MEDEWERKER=3 AND A.HER_JAAR BETWEEN 2005 AND 2005 AND A.HER_MAAND
BETWEEN 10 AND 10 AND NVL(F.B_NOOIT_MEER_UITNODIGEN,0)=0 AND A.CLIENT_ID NOT
IN (SELECT C.CLIENT_ID FROM AGENDA C WHERE C.D_AFSPRAAK_VAN >
TO_DATE('20050825','YYYYMMDD') AND C.B_HERHALING=1 AND C.C_SRT_ONDERZOEK=211)
ORDER BY F.GESLACHTSNAAM;
Any help is great.
WHERE A.AFWIJKING_ID=B.AFWIJKING_ID (+)
AND B.C_SRT_AFWIJKING=C.C_SRT_AFWIJKING (+) AND A.C_VERWEZEN_NAAR=D.C_VERWEZEN_NAAR
(+) AND A.C_SRT_AKTIE=E.C_SRT_AKTIE (+) AND A.CLIENT_ID=F.CLIENT_ID (+)
AND A.C_MEDEWERKER=3 AND A.HER_JAAR BETWEEN 2005 AND 2005 AND A.HER_MAAND
BETWEEN 10 AND 10 AND NVL(F.B_NOOIT_MEER_UITNODIGEN,0)=0 AND A.CLIENT_ID NOT
IN (SELECT C.CLIENT_ID FROM AGENDA C WHERE C.D_AFSPRAAK_VAN >
TO_DATE('20050825','YYYYMMDD') AND C.B_HERHALING=1 AND C.C_SRT_ONDERZOEK=211)
ORDER BY F.GESLACHTSNAAM;
Any help is great.