select * from travel_app tp left join (select TRAVEL_APP_NO fno, listagg(EMP_NAME,' , ') within group (order by EMP_ID) fname from TRAVEL_FOLLOWER group by TRAVEL_APP_NO) tf on tp.no=tf.fno
oracle11g 特性
最新推荐文章于 2024-06-27 09:35:57 发布