Question

科讯跪求-如何用sql标签在父栏目下调用所有子栏目的文章标题

跪求-如何用sql标签在父栏目下调用所有子栏目的文章标题

Answer 1

select top id,title from ks_article where tid in(select id from ks_class where ts like '%{$Param(0)}%') and verific=1 order by id desc调用{SQL_标签名称(一级栏目ID)}

Answer 2

哎了，你就不知道看看呀，照着复制你也太强了。select top 10id,Tid,verific,title from ks_article where tid in(select id from ks_class where ts like '%{$Param(0)}%') and verific=1 order by id desc看红色的。。。

Answer 3

谢谢斑竹，好像不正确，提示select语句不对