提示语法错误 (操作符丢失)，是怎么回事？

我用下面的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表达式