IDE extension that lets you fix coding issues before they exist!
Setup is effortless and analysis is automatic for most languages
Fast, accurate analysis; enterprise scalability
SELECT with JOIN always performs better than nested selects.
SELECT
JOIN
SELECT * FROM SPFL INTO SPFLI_WA. SELECT * FROM SFLOGHT INTO SFLIGHT_WA WHERE CARRID = SPFLI_WA-CARRID AND CONNID = SPFLIGHT_WA_CONNID. ENDSELECT. ENDSELECT.
