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