Toad World® Forums

OUTER JOIN causes syntax hit

12.11.0.43

This statement causes a syntax hit on OUTER:

SELECT R1TYFL, R1OCDE, R1RQBT, R1RQSQ, R2PTSK, R1DOCO, R1DCTO, R1KCOO, R2LNID, R1LNID,
R1PSTB, R1RCDJ, R1ITM, R1MCU
FROM PRODDTA.F4600
OUTER JOIN PRODDTA.F4611
ON R1TYFL=R2TYFL AND R1OCDE=R2OCDE AND R1RQBT=R2RQBT AND R1RQSQ=R2RQSQ;

Although this is the exact script that Toad generated, and it works just fine.

Thanks!
Rich