Select distinct b.Nodeid from(Select ParentNode from A,B where a.Nodeid=b.Nodeid and A.Userid=1)tmp,B
where Charindex('>'+Cast(tmp.ParentNode as varChar(4))+'>','>'+b.NodePath)>0
Select b.Nodeid from(Select ParentNode from A,B where a.Nodeid=b.Nodeid and A.Userid=1)tmp,B
where Charindex('>'+Cast(tmp.ParentNode as varChar(4))+'>','>'+b.NodePath)>0