Question

科讯SQL 怎么读取某个大栏目下的子栏目

SQL标签 怎么读取某个大栏目下的子栏目？高手一下？

Answer 1

父栏目及子栏目select top {$Param(0)} ID,Title,PhotoUrl,Price,Price_Original from KS_Product where tid in(select id from ks_class where ts like '%{$Param(1)}%') and Popular=1 and Verific=1 and DelTF=0 order by id desc父栏目下的子栏目select top {$Param(0)} ID,Title,PhotoUrl,Price,Price_Original from KS_Product where tn='{$Param(1)}' and Popular=1 and Verific=1 and DelTF=0 order by id desc调用{SQL_标签(num,tid)}以上是依商城为例，其他模型类推