杭州交通信息网货到付款拒签怎么办:vb 中的sql语句总是报错？
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/28 09:18:25
连接的是access的数据库，下面的查询语句在access中就没问题，改下格式放到vb中就提示select语句中包含一个保留字，拼写错误或。。。。。。
紧急求助啊
"SELECT dwbh, dwmc, BM, count(*) as sum, Sum(总计) AS 合计, Sum(ENHJ之Sum) AS ENHJ, " _
+ "Sum([Sum 之 JBGX]) AS [JBGX],Sum([Sum 之 YJGX]) AS [YJGX], Sum([Sum 之 XYGX]) AS [XYGX], Sum([Sum 之 JSJT]) AS [JSJT], " _
+ "Sum([Sum 之 GGJT]) AS [GGJT], Sum([Sum 之 JBGZ]) AS [JBGZ], Sum([Sum 之 ZDBC]) AS [ZDBC], Sum([Sum 之 ENQT]) AS [ENQT], " _
+ "Sum([Sum 之 ENQT2]) AS [ENQT2], Sum(ewzhj) AS ew, Sum([Sum 之 DTNF]) AS [DTNF], Sum([Sum 之 SHBT]) AS [SHBT], " _
+ "Sum([Sum 之 LBF]) AS [LBF], Sum([Sum 之 TXF]) AS [TXF], Sum([Sum 之 qt]) AS [qt],Sum(KKHJ) AS KK, Sum([Sum 之 ZF]) AS [ZF], " _
+ "Sum([Sum 之 YLJ]) AS [YLJ], Sum([Sum 之 SYBX]) AS [SYBX], Sum([Sum 之 JBYL]) AS [JBYL], Sum([Sum 之 BCYL]) AS [BCYL]," _
+ "Sum([Sum 之 SJ]) AS [SJ], Sum([Sum 之 KCQT]) AS [KCQT], Sum(SFJE) AS SF from" _
+ "(SELECT x_mxb.DWBH,x_dwb.dwmc, x_mxb.BM,x_mxb.zgbh, Sum([x_mxb].[ENHJ]+[x_mxb].[ewhj]) AS 总计,Sum(x_mxb.ENHJ) AS ENHJ之Sum, " _
+ "Sum([X_MXB].[JBGX]) AS [Sum 之 JBGX],Sum([X_MXB].[YJGX]) AS [Sum 之 YJGX], " _
+ "Sum([X_MXB].[XYGX]) AS [Sum 之 XYGX], Sum([X_MXB].[JSJT]) AS [Sum 之 JSJT], " _
+ "Sum([X_MXB].[GGJT]) AS [Sum 之 GGJT], Sum([X_MXB].[JBGZ]) AS [Sum 之 JBGZ], " _
+ "Sum([X_MXB].[ZDBC]) AS [Sum 之 ZDBC], Sum([X_MXB].[ENQT]) AS [Sum 之 ENQT], " _
+ "Sum([X_MXB].[ENQT2]) AS [Sum 之 ENQT2], Sum([X_MXB].[EWHJ]) AS ewzhj," _
+ "Sum([X_MXB].[DTNF]) AS [Sum 之 DTNF], Sum([X_MXB].[SHBT]) AS [Sum 之 SHBT], " _
+ "Sum([X_MXB].[LBF]) AS [Sum 之 LBF], Sum([X_MXB].[TXF]) AS [Sum 之 TXF], " _
+ "Sum([X_MXB].[qt]) AS [Sum 之 qt],Sum([X_MXB].[KKHJ]) AS KKHJ, Sum([X_MXB].[ZF]) AS [Sum 之 ZF], " _
+ "Sum([X_MXB].[YLJ]) AS [Sum 之 YLJ], Sum([X_MXB].[SYBX]) AS [Sum 之 SYBX]," _
+ "Sum([X_MXB].[JBYL]) AS [Sum 之 JBYL], Sum([X_MXB].[BCYL]) AS [Sum 之 BCYL]," _
+ "Sum([X_MXB].[SJ]) AS [Sum 之 SJ], Sum([X_MXB].[KCQT]) AS [Sum 之 KCQT], Sum([X_MXB].[SFJE]) AS SFJE " _
+ "From x_mxb inner join x_dwb on x_mxb.dwbh=x_dwb.dwbh Where ([X_MXB].[DWBH] = '069') And " _
+ "(Format([X_MXB].[FFSJ], 'yyyy-mm') = '2006-06' ) GROUP BY [X_MXB].[DWBH], x_dwb.dwmc, x_mxb.zgbh, [X_MXB].bm order by bm) as a group by dwbh,dwmc,bm order by bm"
紧急求助啊
"SELECT dwbh, dwmc, BM, count(*) as sum, Sum(总计) AS 合计, Sum(ENHJ之Sum) AS ENHJ, " _
+ "Sum([Sum 之 JBGX]) AS [JBGX],Sum([Sum 之 YJGX]) AS [YJGX], Sum([Sum 之 XYGX]) AS [XYGX], Sum([Sum 之 JSJT]) AS [JSJT], " _
+ "Sum([Sum 之 GGJT]) AS [GGJT], Sum([Sum 之 JBGZ]) AS [JBGZ], Sum([Sum 之 ZDBC]) AS [ZDBC], Sum([Sum 之 ENQT]) AS [ENQT], " _
+ "Sum([Sum 之 ENQT2]) AS [ENQT2], Sum(ewzhj) AS ew, Sum([Sum 之 DTNF]) AS [DTNF], Sum([Sum 之 SHBT]) AS [SHBT], " _
+ "Sum([Sum 之 LBF]) AS [LBF], Sum([Sum 之 TXF]) AS [TXF], Sum([Sum 之 qt]) AS [qt],Sum(KKHJ) AS KK, Sum([Sum 之 ZF]) AS [ZF], " _
+ "Sum([Sum 之 YLJ]) AS [YLJ], Sum([Sum 之 SYBX]) AS [SYBX], Sum([Sum 之 JBYL]) AS [JBYL], Sum([Sum 之 BCYL]) AS [BCYL]," _
+ "Sum([Sum 之 SJ]) AS [SJ], Sum([Sum 之 KCQT]) AS [KCQT], Sum(SFJE) AS SF from" _
+ "(SELECT x_mxb.DWBH,x_dwb.dwmc, x_mxb.BM,x_mxb.zgbh, Sum([x_mxb].[ENHJ]+[x_mxb].[ewhj]) AS 总计,Sum(x_mxb.ENHJ) AS ENHJ之Sum, " _
+ "Sum([X_MXB].[JBGX]) AS [Sum 之 JBGX],Sum([X_MXB].[YJGX]) AS [Sum 之 YJGX], " _
+ "Sum([X_MXB].[XYGX]) AS [Sum 之 XYGX], Sum([X_MXB].[JSJT]) AS [Sum 之 JSJT], " _
+ "Sum([X_MXB].[GGJT]) AS [Sum 之 GGJT], Sum([X_MXB].[JBGZ]) AS [Sum 之 JBGZ], " _
+ "Sum([X_MXB].[ZDBC]) AS [Sum 之 ZDBC], Sum([X_MXB].[ENQT]) AS [Sum 之 ENQT], " _
+ "Sum([X_MXB].[ENQT2]) AS [Sum 之 ENQT2], Sum([X_MXB].[EWHJ]) AS ewzhj," _
+ "Sum([X_MXB].[DTNF]) AS [Sum 之 DTNF], Sum([X_MXB].[SHBT]) AS [Sum 之 SHBT], " _
+ "Sum([X_MXB].[LBF]) AS [Sum 之 LBF], Sum([X_MXB].[TXF]) AS [Sum 之 TXF], " _
+ "Sum([X_MXB].[qt]) AS [Sum 之 qt],Sum([X_MXB].[KKHJ]) AS KKHJ, Sum([X_MXB].[ZF]) AS [Sum 之 ZF], " _
+ "Sum([X_MXB].[YLJ]) AS [Sum 之 YLJ], Sum([X_MXB].[SYBX]) AS [Sum 之 SYBX]," _
+ "Sum([X_MXB].[JBYL]) AS [Sum 之 JBYL], Sum([X_MXB].[BCYL]) AS [Sum 之 BCYL]," _
+ "Sum([X_MXB].[SJ]) AS [Sum 之 SJ], Sum([X_MXB].[KCQT]) AS [Sum 之 KCQT], Sum([X_MXB].[SFJE]) AS SFJE " _
+ "From x_mxb inner join x_dwb on x_mxb.dwbh=x_dwb.dwbh Where ([X_MXB].[DWBH] = '069') And " _
+ "(Format([X_MXB].[FFSJ], 'yyyy-mm') = '2006-06' ) GROUP BY [X_MXB].[DWBH], x_dwb.dwmc, x_mxb.zgbh, [X_MXB].bm order by bm) as a group by dwbh,dwmc,bm order by bm"