摘要:
with aa(a,b,c)as( select PROJECT_ID,PROJECT_NAME,PARENT_PROJECT_ID from T_PROJECT --where PARENT_PROJECT_ID is not null),mm(PROJECT_ID,PROJECT_NAME,PARENT_PROJECT_ID,PARENT_PROJECT_NAME) as( select distinct aa.a,aa.b,aa.c,p.PROJECT_NAME from aa left join T_PROJECT p on aa.c = p.PROJECT_ID)select * f 阅读全文