VIEW_RLLX_PARAM_ENTTITY
SELECT RLLX_PARAM_ENTITY.vin AS vin, Max(IIf(PARAM_CODE='CT_BSQXS',PARAM_VALUE,0)) AS CT_BSQXS, Max(IIf(PARAM_CODE='CT_ZHGKCO2PFL',PARAM_VALUE,0)) AS CT_ZHGKCO2PFL, Max(IIf(PARAM_CODE='CT_QGS',PARAM_VALUE,0)) AS CT_QGS, Max(IIf(PARAM_CODE='CT_SJGKRLXHL',PARAM_VALUE,0)) AS CT_SJGKRLXHL, Max(IIf(PARAM_CODE='CT_SQGKRLXHL',PARAM_VALUE,0)) AS CT_SQGKRLXHL, Max(IIf(PARAM_CODE='CT_BSQDWS',PARAM_VALUE,0)) AS CT_BSQDWS, Max(IIf(PARAM_CODE='CT_PL',PARAM_VALUE,0)) AS CT_PL, Max(IIf(PARAM_CODE='CT_QTXX',PARAM_VALUE,0)) AS CT_QTXX, Max(IIf(PARAM_CODE='CT_ZHGKRLXHL',PARAM_VALUE,0)) AS CT_ZHGKRLXHL, Max(IIf(PARAM_CODE='CT_EDGL',PARAM_VALUE,0)) AS CT_EDGL, Max(IIf(PARAM_CODE='CT_FDJXH',PARAM_VALUE,0)) AS CT_FDJXH, Max(IIf(PARAM_CODE='CT_JGL',PARAM_VALUE,0)) AS CT_JGL
FROM RLLX_PARAM_ENTITY
GROUP BY RLLX_PARAM_ENTITY.vin;
VIEW_T_ALL
SELECT FC_CLJBXX.VIN, FC_CLJBXX.USER_ID, FC_CLJBXX.QCSCQY, FC_CLJBXX.JKQCZJXS, FC_CLJBXX.CLZZRQ, FC_CLJBXX.UPDATETIME, FC_CLJBXX.CLXH, FC_CLJBXX.HGSPBM, FC_CLJBXX.CLZL, FC_CLJBXX.YYC, FC_CLJBXX.QDXS, FC_CLJBXX.ZWPS, FC_CLJBXX.ZCZBZL, FC_CLJBXX.ZDSJZZL, FC_CLJBXX.JYBGBH, FC_CLJBXX.JYJGMC, FC_CLJBXX.TYMC, FC_CLJBXX.ZGCS, FC_CLJBXX.EDZK, FC_CLJBXX.LTGG, FC_CLJBXX.LJ, FC_CLJBXX.ZJ, FC_CLJBXX.RLLX, VIEW_RLLX_PARAM_ENTTITY.CT_BSQDWS, VIEW_RLLX_PARAM_ENTTITY.CT_BSQXS, VIEW_RLLX_PARAM_ENTTITY.CT_EDGL, VIEW_RLLX_PARAM_ENTTITY.CT_FDJXH, VIEW_RLLX_PARAM_ENTTITY.CT_JGL, VIEW_RLLX_PARAM_ENTTITY.CT_PL, VIEW_RLLX_PARAM_ENTTITY.CT_QGS, VIEW_RLLX_PARAM_ENTTITY.CT_QTXX, VIEW_RLLX_PARAM_ENTTITY.CT_SJGKRLXHL, VIEW_RLLX_PARAM_ENTTITY.CT_SQGKRLXHL, VIEW_RLLX_PARAM_ENTTITY.CT_ZHGKCO2PFL, VIEW_RLLX_PARAM_ENTTITY.CT_ZHGKRLXHL
FROM FC_CLJBXX LEFT JOIN VIEW_RLLX_PARAM_ENTTITY ON FC_CLJBXX.VIN = VIEW_RLLX_PARAM_ENTTITY.VIN
WHERE (((FC_CLJBXX.RLLX)='汽油' Or (FC_CLJBXX.RLLX)='柴油' Or (FC_CLJBXX.RLLX)='两用燃料' Or (FC_CLJBXX.RLLX)='双燃料') AND ((FC_CLJBXX.status)='0'));