1 WITH a AS2 (3 SELECT * FROM dbo.db_UserGroup WHERE TB_UserGroupID=14 UNION ALL SELECT s.* FROM dbo.db_UserGroup AS s,a WHERE s.FK_Par ...
1 WITH a AS2 (3 SELECT * FROM dbo.db_UserGroup WHERE TB_UserGroupID=14 UNION ALL SELECT s.* FROM dbo.db_UserGroup AS s,a WHERE s.FK_ParentId=a.TB_UserGroupID5 )6 SELECT * FROM a
海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理:https://www.xlkjsw.com
原标题:sql server根据一级分类查询所有子级分类
关键词:sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。