oracle视图表连接

with tmp as (
     select a.id,b.name from test001 a 
     left join test002 b on a.tid = b.id
)
 
select 
     b.name,
     c.name 
from test03 a
left join tmp b on a.one = b.id
left join tmp c on a.two = c.id

————————————————
版权声明：本文为CSDN博主「墨 尘」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/m_crayon/article/details/109374345