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