sql - Oracle DB 只需并排合并两个表

Question

1:表国家

ID NAME   
1  USA  
2  BRITAIN

2:表人

P_ID        P_NAME  
4           JOHN  
5           MONTY

结果表应该有

ID   NAME        P_ID     P_NAME  
1    USA         4       JOHN  
2    BRITAIN     5       MONTY

并排合并。可能吗？喜欢表1 |表2

Answer 1

例子

with x as (
select id, name, rownum rn from country
order by id),
y as(
select p_id, p_name, rownum rn from people
order by p_id)
select id,name,p_id,p_name from x
left join y on y.rn = x.rn
union  
select id,name,p_id,p_name from y
left join x on y.rn = x.rn