–樹形sql查詢
WITH TREE AS( –創建一個虛擬表
SELECT * FROM sys_organiz –指定需要查詢的表
WHERE organize_code = ‘100000’ — 指定父節點條件
UNION ALL –聯合查詢
SELECT sys_organiz.* FROM sys_organiz,TREE
WHERE TREE.organize_code = sys_organiz.organize_parent_code
)
SELECT * FROM TREE;