Hi, I have simple master table which has Name, Score for Dec-19, Jan-20, Feb-20, Mar-20, April-20 and May-20 and i will receive new file end of June-20 month with updated score for last 6 months which will have data for Jan-20, Feb-20,Mar-20, Apr-20, May-30 and Jun-20.
I need a query to update the master file by including June data from new file along with upadting Jan-20, Feb-20,Mar-20, Apr-20 and May-30 data.
My expected result in Master table would be Name, Dec-19, Jan-20, Feb-20, Mar-20, April-20, May-20 and June-20.
Please help to create query to solve the above issue
Thank you in advance.