SQL求教。急急急急急！

[cxy12586]

求助：图片中左侧为一张表中的数据，想要得到右侧的结果，SQL怎么实现？

[学海无涯-回头是岸]

逻辑关系没看懂

[nayi_224]

with tab1 as (
select table_id1, table_id2
  from table_a
 start with table_id1 = 'TABLE_A'
connect by prior table_id2 = table_id1
)
select table_id1 from tab1
union 
select table_id2 from tab1
order by table_id1
;

[Wazy_csdn]

select COLUMN1
  from test_insert3
 start with COLUMN1 = 'T_A'
connect by prior COLUMN2 = COLUMN1
UNION
select COLUMN2
  from test_insert3
 start with COLUMN1 = 'T_A'
connect by prior COLUMN2 = COLUMN1

[wildwolv]

select dept_name from (select t.dept_id, t.dept_name, t.dept_code, t.par_dept_id, level
from SYS_DEPT t
start with t.dept_id = '40288ac45a3c1e8b015a3c28b4ae01d6'
connect by prior t.dept_id = t.par_dept_id
order by level, t.dept_code) order by level

[yaiger]

我也没看到这个结果是怎么回事？没看出树状结构来

[风影萧诺]

select DISTINCT TABLE_ID1 FROM TABLE_A
UNION
select DISTINCT TABLE_ID2 FROM TABLE_A

[邹小青]

这是一个关于多表关联的问题，试试看《如何优化JOIN性能》这篇文章能否帮到您

[weixin_44200964]

这个使用树形查询即可，起点table_a，优先（prior）a以及a的下属，下属的下属，下属的下属 start with /connect by.