Govind - Please try to understand that both the Tables (A and B) are not at the same grain. Table A is at Yearly Time Grain and Table B has deeper granularity (for one year, it returns many records). So if these two tables joined with the key "Year" then records will be duplicated and that is expected. Use data blending instead. Have a look into the KB article, this will help:
It's the common naming convention issue, either give it a alias or rename it to avoid unwanted association.
Hope it helps!!!!!!!!!
What kind of database you are reading?
Maybe you can make a union in SQL. It would solve your problem, but depends on your database.