with t1 as ( select '202301' NY ,'1' id,'name1' name from dual union select '202301' NY ,'2' id,'name2' name from dual ), t2 as ( select '20230101' RQ ,'111' id,'name111' name from dual union select '20230102' RQ ,'222' id,'name222' name from dual union select '20230103' RQ ,'333' id,'name333' name from dual ) SELECT * FROM T1 UNION ALL SELECT * FROM T2 ; 这段如何转成下图这样 |
0
|
|