SQL view, how to append results from tableB with the results from tableA
with cte1(Name, Year) as ( select Name, null as year from tablea),
cte2(Name, Year) as (select NULL as Name, year from tableb)
Select Name, Year from CTE1
UNION ALL
select Name, Year from CTE2


This should work, didn't read the question properly last answer :)