我用下面的sql语句查询
select * from meet where flag=1 and fj> =98 and fj <=198 " & "order by city,area,bzw desc
提示错误如下：
():[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'flag=1 and fj> =98 and fj <=198order by city,area,bzw desc ' 中
请大家帮忙指教！
------解决方案--------------------
select * from meet where flag=1 and fj> =98 and fj <=198 order by city,area,bzw desc
你的连接符号之间没留空格，系统把这个语句识别成
select * from meet where flag=1 and fj> =98 and fj <=198order by city,area,bzw desc
了
------解决方案--------------------
sql= "select * from meet where flag=1 and fj> =98 and fj <=198 order by city,area,bzw desc "
假如要使用&连接，那么请记住要有空格& " order by ... "
------解决方案--------------------
路过，学习
------解决方案--------------------
select * from meet where flag=1 and fj> =98 and fj <=198 order by city,area,bzw desc
------解决方案--------------------
直接写不就得了，干嘛要连接
select * from meet where flag=1 and fj> =98 and fj <=198 order by city,area,bzw desc
确实要，那么就
"select * from meet where flag=1 and fj> =98 and fj <=198 "& " order by city,area,bzw desc "
------解决方案--------------------
"select * from meet where flag=1 and fj> =98 and fj <=198 " & "order by city,area,bzw desc "
"select * from meet where flag=1 and fj> =98 and fj <=198 order by city,area,bzw desc "
"select * from meet where "& "flag=1 and "& "fj> =98 "& " and fj <=198 order by city,area,bzw desc "
写法多着去了,
建议楼主多看看SQL表达式