这是表1：
这是表2：
想得到的结果是这个：
怎么写语句？

有没有大佬帮帮忙看下

一个左连就好

select t1.nian,t1.yue,t1.number1,t2.number2,t1.name from 表1 yunjiu t1 left join 表2 t2 on t1.nian=t2.nian and t1.yue=t2.yue and t1.name=t2.name
union
select t2.nian,t2.yue,t1.number1,t2.number2,t2.name from 表1 t1 right join 表2 t2 on t1.nian=t2.nian and t1.yue=t2.yue and t1.name=t2.name

select isnull(t1.nian,t2.nian) nian,isnull(t1.yue,t2.yue) yue,t1.number1,t2.number2,isnull(t1.name ,t2.name) name
from 表1 yunjiu t1
full join 表2 t2
on t1.nian=t2.nian and t1.yue=t2.yue and t1.name=t2.name