Who are the different players, what season do they play in, and what is the name of the team they are on?
select t1.season, t1.player, t2.name from match_season as t1 join team as t2 on t1.team = t2.team_id