|
![](https://clubstatic.excelhome.net/image/common/ico_lz.png)
楼主 |
发表于 2011-5-1 17:50
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
原帖由 zhaogang1960 于 2011-5-1 17:23 发表 ![](http://club.excelhome.net/images/common/back.gif)
Sub Macro1()
Dim cnn As Object, SQL$
Dim iii As String
iii = "a"
Set cnn = CreateObject("ADODB.Connection")
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Ex ...
请问一下,我下面语句怎么提示操作符丢失,我总找不到错误在哪?调试时,所有变量都能找到.
"SELECT a.kmdm,a.kmmc,a.bqjr,a.ljjr,a.byjr,b.bqjr,b.ljjr,b.byjr FROM (select * form " & goa & " where szlx='" + szlxb + "' and qxbz='" + qxbzb + "' and bbjc='" + bbjcb + "' )a left join (select * form " & gob & " where szlx='" + szlxb + "' and qxbz='" + qxbzb + "' and bbjc='" + bbjcb + "' )b on a.kmdm=b.kmdm order by a.kmdm "
"SELECT a.kmdm,b.kmdm FROM (select * form tmis ) as a left join (select * form tcbs ) as b on a.kmdm=b.kmdm order by a.kmdm " 也不行,唉form错了,应from,不好意思
[ 本帖最后由 saler111 于 2011-5-1 17:59 编辑 ] |
|