大家帮我看一下这个SQL语句对不对呢，就是不能执行。

[bobshi]

select * from tb_chushou_info where 小区='1111' and ( 房型='一房一厅' or 房型='二房' ) and 楼层 between 5 to 7 and 住房面积 between 60 to 90 and 售价 between 10 to 15

谢谢!!

[bobshi]

我用的是access

[zbcosmos]

小区='1111' and 房型='一房一厅' or 房型='二房'
改成－－＞
小区 like '1111' and 房型 like'一房一厅' or 房型 like '二房'