报了个字段找不到，麻烦大神帮我看一下我真的看不出了啦

[佳爺]

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=?

[XGrscM]

小伙维护的是国企的项目吧，一眼看去全是拼音缩写

[Juwell16]

谁给我写这种语句，直接滚蛋

[源者鬼道]

这操作也是可以，发这么一大段你让别人怎么帮你找，不会先格式化一下，再发出来吗，格式化不会吗，百度

[韩_师兄]

报错信息提供一下啊

[meet_aas]

字段找不到应该会有报错提示你哪个字段不存在吧 你就细心找一下吧

[冰思雨]

给了一个超级大的SQL语句，没有给出是哪个字段找不到，也没有给出相关表的表结构，难道，你让我掐指一算，猜出来吗？ 嗯........我掐指一算，天昏地暗。

[冰思雨]

1. 需要知道 具体是 哪个字段 找不到，或者，具体的异常信息。 2. 需要知道 SQL 语句相关联的 表结构 信息。

[a584257442]

瑟瑟发抖，这sql看得头皮发麻，这怎么维护

[程序员小雨]

报异常的时候会报那个字段找不到，就行了呗，去控制台的日志里边
自己细心一点

[kakai_ty]

你这....操作秀到我了

[谈谈1974]

问问题也要讲下方式方法呀

[xiaobai_wy]

这样贴出来 让别人怎么看 啊

[NinjaYinJey]

" (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 " ===> "(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

[qkniit]

[泡泡糖@比巴卜]

楼主,贴出你执行完这个sql出现的异常信息截图,让我们看看是什么异常提示的信息.

[大叔obnijeh]

F_BMBH，随便找一个都没有。找不到字段不只一个。格式化后再找。眼花就重新写。

[863922230]

你这sql语句太牛逼了，厉害

[一只三黄鸡]

弄个视图不是挺好

[s478853630]

来秀SQL的吧

[是赵敢敢啊]

目测政府的项目，内网开发，字段全是拼音缩写，简单的就用英文，不会的就就是拼音缩写