表自链接递归查询死循环

SELECT * FROM unitlink u INNER JOIN unitlink l
ON u.ParentunitId = l.childUnitId AND l.ParentunitId = u.childUnitId

posted @ 2018-10-25 08:29  zklve2  阅读(255)  评论(0编辑  收藏  举报