求助mssql语句转成mysql

[gongshunkai3]

with t as (select * from Category where CatId = @CatId union all select a.* from Category as a inner join t as b on a.ParentId = b.CatId) select * from Goods where CatId in (select CatId from t)

mysql似乎不支持with，是不是要用create写个临时表，请大神帮忙写一下，本人对php不熟悉

[hongmei85]

没验证，看下对不对 select * from Goods where CatId in (select CatId from Category where CatId = @CatId union all select CatId from Category where ParentId = @CatId)

[gongshunkai3]

引用 1 楼 hongmei85 的回复:

没验证，看下对不对

select * from Goods where CatId in (select CatId from Category where CatId = @CatId union all select CatId from Category where ParentId = @CatId)

不对，请看结构图，比如商品表某条记录的CatId是6，那么 当分类是2，也能把商品表的CatId是6的记录找到，
简单的说，把某个分类（包括自己）的所有子分类的产品找到。

[gongshunkai3]

自己顶~~~~