SELECT A.VA_REGION_NAME AS AREA_NAME, A.VA_CIG_TRADEMARK AS CIG_NM, B.DE_BS_CXB AS CXB_REL, A.DE_BS_CXB_PRE AS CXB_PREFROM DCDW.FAC_SCC_ZY_REGION_CXB_PRE ALEFT JOIN DCDW.FAC_SCC_ZY_REGION_CXB B ON B.VA_CIG_TRADEMARK = A.VA_CIG_TRADEMARK AND A.VA_REGION_CODE = B.REGION_CODELEFT JOIN DIM_REGION C ON A.VA_REGION_CODE = B.REGION_CODE = C.PROV_CODE OR A.VA_REGION_CODE = B.REGION_CODE = C.AREA_CODEDB2中執(zhí)行SQL語句,一直報(bào)錯(cuò)在 "CODE = B.REGION_CODE" 后面找到異常標(biāo)記 "= C".檢查沒有沒錯(cuò),求大神告知一下
關(guān)于DB2SQL
月關(guān)寶盒
2019-01-02 10:49:25