如果两个表的关系是 1:1 你可以用 UNION ALL 为了 table1 以及连接的查询（如果没有匹配项，则使用左连接） table2 至 table1 检索列的值 country :

select t1.* from table1 t1
union all
select t2.*, t1.country 
from table2 t2 left join table1 t1
on t1.name = t2.name

或使用相关子查询：

select t1.* from table1 t1
union all
select t2.*, (select t1.country from table1 t1 where t1.name = t2.name)
from table2 t2

试试这个

SELECT * FROM TABLE1 t1
   UNION
   Select t2.*, t1.country from table2 t2 
   Join table1 t1 on t2.name=t1.name

这听起来像是一个完全连接：

select *
from table1 t1 full join
     table2 t2
     using (name, event);

如果你的数据库不支持 full join ，您可以使用：

select t1.name, t1.event, t1.country
from table1 t1
union all
select t2.name, t2.event, null
from table2 t2
where not exists (select 1 from table1 t1 where t1.name = t2.name and t1.event = t2.event);