You can probably do it your way, but why not be free as a bird and use sql in a virtual layer:
select t1.x,t1.y, t1.geometry, t2.year
from table1 t1
inner join table2 t2 using (id)
Assuming you have geometry in table1. BTW x is long not lat.
A lot of data stuff in QGIS an be handled with a virtual layer. A lot easier to remember than where a dialog ...