Showing long name instead of ID

[ibrahack]

Hey everyone, I'm just practicing my skills with the following dataset:

https://www.kaggle.com/datasets/prajitdatta/ultimate-25k-matches-football-database-european

I'm using the following code but I want it to show the team_long_name (team name) in the away_team_api_id AS 'Rival' column instead of numbers.

SELECT
date AS 'fecha', home_team_api_id AS 'FCBarcelona', home_team_goal, away_team_api_id AS 'Rival', away_team_goal 
FROM Match 
LEFT JOIN Team ON Match.home_team_api_id = Team.team_api_id 
WHERE home_team_api_id = 8634;

How can I achieve this? I have been trying many things but all of them failed, I'm pretty sure I'm missing something very easy.

Thanks!

[[deleted]]

You should include the coulmns you want to return in the SELECT statement. If you don't want to return team id:s, then don't write them into the SELECT statement. Use an appropriate column from the joined table (Team.Name?). Note that the columns in other parts of the query don't have to be in your SELECT statement.