try this
select table1.ID,table1.NAME,table1.Team ,table2.Type,MAXYEAR.Year,Max(Month) as Month ,Max(Amount) as Amount from table1 INNER JOIN table2 on table1.ID = table2.ID
Inner join
(select table1.ID,table2.Type,MAX(Year) as Year from table1 INNER JOIN table2 on table1.ID = table2.ID
group...