Hi friends, it's difficult to elaborate. Let's say for Table A, I have column 'firmname' and 'dealyear' representing when a M&A deal was taken place. and for Table B I have column 'firmname', '2015', '2016', '2017', '2018', and '2019', representing annual average stock value of the company. Now I wanna add column called 'stockprice' in table A, thus, for the respective deal info in table A there would be a stock value of the company, of the year. Can anyone let me know how to achieve this? example of table A: Company_Name dealyear stockprice ( to be added with the value from Table B) Abcam plc 2000 Abeona Therapeutics Inc 1999 Abiomed Inc 2001 Acadia Healthcare 2002 example of table B: Company_Name _1999 _2000 _2001 _2002 Abcam plc 6.648748 7.526305 14.21621 17.03757 Abeona Therapeutics Inc 602.3358 1363.622 933.9541 667.004 Abiomed Inc 8.457992 24.72086 20.06118 7.379444 Acadia Healthcare 4.092705 4.483808 1.457923 2.454762
... View more