Oracle 关联自己
SELECT T.ID, CASE WHEN T.PARENT_ID = 0 THEN T.NAME ELSE T2.NAME END AS NAME, CASE WHEN T.PARENT_ID = 0 THEN T.R ELSE T2.R END AS R, D.NAME AS RNAME FROM INFO T LEFT JOIN INFO T2 ON T.PARENT_ID = T2.ID LEFT JOIN DOMAIN D ON (T.R || T2.R) = D.ID
?
