is completely wrong.
You will need a
on one table and a
column on the other that refers back to the first one.
The select then becomes something like
select year, batch
left join tb2 on tb1.key = tb2.foreignkey
There is a tutorial on how to write MySQL queries at tutorialspoint
If you have many columns that you want to match on between the tables then just add those columns to the ON clause. Eg
left join tb2 on tb1.key = tb2.foreignkey and tb1.col2 = tb2.col2 and tb1.col3 = tb2.col3 etc