如何在数据库中查询某一分类的全部文章？

1. SELECT `supe_spaceitems`.`subject`, `supe_spacenews`.`message`
   
2. FROM supe_spaceitems, supe_spacenews
   
3. WHERE (`supe_spaceitems`.`catid` =17)
   
4. AND ('supe_spaceitems'.'itemid'='supe_spacenews'.'itemid')
   

复制代码

这样执行不了，要是去掉AND后的条件，出来的结果又不对