WITH tab AS( SELECT * FROM table1 WHERE Id='9' UNION ALL SELECT * FROM tab,table1 WHERE table1.Id=tab.ParentId ) SELECT * FROM tab;
87duan 2021-07-21 14:36 原文
WITH tab AS( SELECT * FROM table1 WHERE Id='9' UNION ALL SELECT * FROM tab,table1 WHERE table1.Id=tab.ParentId ) SELECT * FROM tab;