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_CARTICLEID