|
楼主 |
发表于 2011-5-1 17:50
|
显示全部楼层
原帖由 zhaogang1960 于 2011-5-1 17:23 发表
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 编辑 ] |
|