>SELECT CONFIGFILES.*, ; > PARAMETERS.CNAME, ; > PARAMETERS_A.CNAME, ; > PARAMETERS_B.CNAME, ; > PARAMETERS_C.CNAME ; > FROM GULFSTREAM!CONFIGFILES ; > LEFT JOIN GULFSTREAM!PARAMETERS ; > LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_A ; > LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_B ; > LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_C ; > ON CONFIGFILES.IREMOTEPARAM4 = PARAMETERS_C.IPARAMID ; > ON CONFIGFILES.IREMOTEPARAM3 = PARAMETERS_B.IPARAMID ; > ON CONFIGFILES.IREMOTEPARAM2 = PARAMETERS_A.IPARAMID ; > ON CONFIGFILES.IREMOTEPARAM1 = PARAMETERS.IPARAMID ; > WHERE CARTICLEID = ?VP_CARTICLEID>
SELECT CONFIGFILES.*, ; PARAMETERS.CNAME, ; PARAMETERS_A.CNAME, ; PARAMETERS_B.CNAME, ; PARAMETERS_C.CNAME ; FROM GULFSTREAM!CONFIGFILES ; LEFT JOIN GULFSTREAM!PARAMETERS ; ON CONFIGFILES.IREMOTEPARAM1 = PARAMETERS.IPARAMID ; LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_A ; ON CONFIGFILES.IREMOTEPARAM2 = PARAMETERS_A.IPARAMID ; LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_B ; ON CONFIGFILES.IREMOTEPARAM3 = PARAMETERS_B.IPARAMID ; LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_C ; ON CONFIGFILES.IREMOTEPARAM4 = PARAMETERS_C.IPARAMID ; WHERE CARTICLEID = ?VP_CARTICLEIDAlso you might need to specify the alias for CARTICLEID field.