WITH RPL (ID,ParentID,NAME) AS
(
SELECT OPER_LABEL_TYPE as id ,LABEL_FATHER_TYPE as ParentID,LABEL_TYPE_NME as NAME FROM ncc_view.OPER_LABEL_TYPE WHERE OPER_LABEL_TYPE= ‘534050b6735e4a778884d873312af104’
UNION ALL
SELECT child.OPER_LABEL_TYPE as id,child.LABEL_FATHER_TYPE as ParentID,child.LABEL_TYPE_NME as name FROM RPL parent,ncc_view.OPER_LABEL_TYPE child WHERE parent.id=child.LABEL_FATHER_TYPE
)
SELECT * FROM RPL
db2级联查询
最新推荐文章于 2021-09-22 17:58:19 发布