Access的语句也支持联合查询的啊
如果知道最多节点深度最多为3
select * from a where pid=@pid
union
select * from a ,(select id from a where pid=@pid)b where a.Pid=b.id
union
select * from a ,(select id from a ,(select id from a where pid=@pid)b where a.Pid=b.id)c
where a.Pid=c.id
如果知道最多节点深度最多为3
select * from a where pid=@pid
union
select * from a ,(select id from a where pid=@pid)b where a.Pid=b.id
union
select * from a ,(select id from a ,(select id from a where pid=@pid)b where a.Pid=b.id)c
where a.Pid=c.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货