select top 2 ID,Tid,Title,Adddate,Picurl,PicNews,Verific from KS_Article where verific=1 and PicNews=1 and tid='20070830246627' or tid='20070891722356' or tid='20070330462617' order by adddate desc
为什么我的PicNews=1没有起作用呢?
还有
select top 10 ID,Tid,Title,Adddate,Popular,TitleFontColor,Verific,from KS_Article where verific=1 and Popular=1 and tid='20070830246627' or tid='20079195312876' or tid='20078506322891' or tid='20078506322891' or tid='20072367100653' or tid='20071945298218' or tid='20078419238853' or tid='20072018314922' or tid='20077041379697' or tid='20078465003516' or tid='20078387908668' or tid='20074771532440' or tid='20071724706906' or tid='20070891722356' or tid='20070330462617' order by Adddate desc
Popular=1也不起作用,给我指点一下好吗,谢谢。