标题: Oracle关联自己 [打印本页] 作者: ㄣ负二代 时间: 2013-6-29 16:51 标题: Oracle关联自己 Oracle关联自己 Java代码
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 作者: 宇智波·佐助 时间: 2013-7-7 18:12
盯上了