Your
on
is completely wrong.
You will need a
key
on one table and a
foreign key
column on the other that refers back to the first one.
The select then becomes something like
select year, batch
from tb1
left join tb2 on tb1.key = tb2.foreignkey
There is a tutorial on how to write MySQL queries
at tutorialspoint[
^]
[Edit]
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