提示语法错误 (操作符丢失)，是怎么回事？
我用下面的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表达式
