请问满足这样条件的Sql语句怎么写？谢谢

[ervinlj]

有这样一个Sql语句：
select top 50 * from biz where shenhe=1 and title like '%商机%' or main like '%商机%' order by sj desc
我要实现的结果是当title或者main字段满足筛选字段的情况下，shenhe字段都要为1,象我上面的Sql语句是错误的 结果中会包括shenhe为0的记录。
要实现这样结果的Sql语句应该怎样写呢？问题解决，马上给分 谢!

[akuzou]

select top 50 * from biz where shenhe=1 and (title like '%商机%' or main like '%商机%' order by sj desc)

[chuifengde]

select top 50 * from biz where shenhe=1 and (title like '%商机%' or main like '%商机%') order by sj desc

[akuzou]

select top 50 * from biz where shenhe=1 and (title like '%商机%' or main like '%商机%') order by sj desc

[wlinglong]

select top 50 * from biz where shenhe=1 and (title like '%商机%' or main like '%商机%') order by sj desc

少个括号

[caixia615]

select top 50 * from(select * from biz where shenhe=1 )a where title like '%商机%' or main like '%商机%' order by sj desc

[marco08]

--try

select top 50 * from biz where shenhe=1 and (title like '%商机%' or main like '%商机%') order by sj desc

[dingjian2008]

就是少个括号嘛........抢分高手