SELECT B.F_BH,TRIM(C.F_UNITID) F_UNITID,TRIM(B.F_SSBM) F_SSBM,BM.F_BMMC F_SSBMMC,TRIM(B.F_SSXM) F_SSXM, XM.F_XMMC F_SSXMMC,B.F_SSMDMGS,B.F_BH CS_BH,B.F_MC CS_MC, BM.F_CBFYDL F_BMSX,C.F_RJLX,C.F_KJZG,C.F_SFQYYS,C.F_SFCGYS,C.ACCOUNT_ID,C.ACCOUNT, B.F_EMAIL,B.F_BGDH,B.F_TEL,BX.F_CXBZ,BX.F_CXBZMC,BX.F_ZSBZ,BX.F_ZSBZMC,BX.F_BZBZ,BX.F_BZBZMC, TRIM(C.F_DFZZJG) F_DFZZJG,(SELECT max(F_MC) FROM CSZZJG WHERE F_ZZJG=C.F_DFZZJG) F_DFZZJGMC, TRIM(C.F_DFXMBH) F_DFXMBH,(SELECT max(F_XMMC) FROM CSXMZD WHERE F_XMBH=C.F_DFXMBH) F_DFXMMC, TRIM(C.F_ZZJG) F_SSZZJG,C.F_MC F_SSZZJGMC,C.F_SKQYBM,BM.F_ISCWB,C.F_SFBMGLHT,C.F_SSDQ, " (SELECT max(F_FJZBWB) FROM CSGSXX WHERE F_GSBM=XM.F_HSJG) F_FJZBWB, (SELECT max(F_MC) FROM CSBZZD WHERE F_BH=(SELECT max(F_FJZBWB) FROM CSGSXX WHERE F_GSBM=XM.F_HSJG)) F_FJZBWBMC, C.F_ZJDW,C.F_ZJDWMC,C.F_GSBM,C.F_GSQC,C.F_SFQYDF,TRIM(C.F_EJDWBM) F_EJDWBM, XM.F_BKBH AS BKBH,(SELECT max(BK.F_MC) FROM CSBKZD BK WHERE BK.F_BKBH=XM.F_BKBH) AS BKMC, (SELECT BK.F_HSCODE FROM CSBKZD BK WHERE BK.F_BKBH=XM.F_BKBH) AS F_HSCODE, XM.F_DQBH AS DQBH,(SELECT max(CT.F_MC) FROM CSDQZD CT WHERE CT.F_BH=XM.F_DQBH) AS DQMC, XM.F_YZDW AS KSBH,(SELECT max(KS.F_DWMC) FROM LSWLDW KS WHERE KS.F_DWBH=XM.F_YZDW) AS KSMC, XM.F_TZYZMS,(SELECT max(F_MC) FROM CSTZYZMS WHERE F_BH=XM.F_TZYZMS) F_TZYZMSMC, XM.F_HSMS,(SELECT max(F_MC) FROM CSXMHSMS WHERE F_BH=XM.F_HSMS) F_HSMSMC, XM.F_JSMS,(SELECT max(F_MC) FROM CSJSMSZD WHERE F_BH=XM.F_JSMS) F_JSMSMC,XM.F_XMNSSD, XM.F_XMFL,XM.F_GCYWLX,XM.F_SFXN,XM.F_HSJG,C.F_YSHS,BX.F_ZSXJ,BX.F_XJMC,C.F_SFGLOA,C.F_OAURL,C.F_SFQYXJBZ,C.F_OATOKEN,C.F_ZXSFFBM, BM.F_BMLX,XM.F_SFXN,BM.F_CBFYDL F_BXSX,(SELECT max(F_MC) FROM CSYWDLZD WHERE F_BH=BM.F_CBFYDL) F_BXSXMC, (SELECT MAX(CLIENT_ID) FROM SIS_UNIT_CLIENT WHERE UNIT_ID=C.F_UNITID) CLIENT_ID FROM CSZGZD B " LEFT JOIN CSGRBXBZ BX ON BX.F_ZZJG=B.F_SSZZJG AND BX.F_ZGBH=B.F_BH LEFT JOIN CSZZJG C ON B.F_SSMDMGS=C.F_GSBM AND C.F_SYZT='1' LEFT JOIN CSBMZD BM ON BM.F_BMBH=B.F_SSBM AND BM.F_SYZT='1' LEFT JOIN CSXMZD XM ON XM.F_XMBH=B.F_SSXM AND XM.F_SYZT='1' WHERE B.F_BH=?

CodePudding user response:

This operation can be, so a large section of the hair you let others how to help you find, not to format, sent to you again, formatting will not, baidu

CodePudding user response:

Give me some error information

CodePudding user response:

Field can not find an error should prompt you which field does not exist, please carefully check