where条件中出现between and 子句就不能用其他条件了吗
例如
select money from table
where money between 100 and 1000
and id> 1101 //如果加这样的条件就报错

[解决办法]
-----try-----

select money from table
where id> 1101 and money between 100 and 1000


[解决办法]
你的id是不是字符型的？


select [money] from table
where [money] between 100 and 1000
and id> '1101 '

[解决办法]
不吧?一些字加[],件加()
select [money] from [table]
where ([money] between 100 and 1000)
and ([id]> 1101)