CREATE TABLE match_season (Season VARCHAR2, Player VARCHAR2, Team VARCHAR2)
CREATE TABLE team (Name VARCHAR2, Team_id VARCHAR2)

Show the season, the player, and the name of the team that players belong to.
SELECT T1.Season, T1.Player, T2.Name FROM match_season AS T1 JOIN team AS T2 ON T1.Team = T2.Team_id
SELECT "T1"."Season", "T1"."Player", "T2"."Name" FROM "match_season" "T1" JOIN "team" "T2" ON "T1"."Team" = "T2"."Team_id"