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

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