Skip to main content
pearl_jan
Participating Frequently
February 14, 2018
Question

Querying same column twice in 1 SQL-statement

  • February 14, 2018
  • 0 replies
  • 693 views

Table "teams":

col 1: team_id (int, 4)

col 2: team_name (varchar, 60)

Table "fixtures":

col 1: date (datetime)

col 2: season (varchar, 9)

col 3: series (varchar, 5)

col 4: home_team_id (int, 4)

col 5: away_team_id (int, 4)

I want to select all fixtures and instead of displaying only the team_id for every fixture, I want to show the team_name. I've tried this one with a JOIN-statement but I can only select 1 team_name at a time instead of the team_name of both home & away team. Thus far, I only get to:

SELECT

fixtures.date,

fixtures.home_team,

fixtures.away_team

FROM fixtures

JOIN teams ON fixtures.home_team_id = teams.team_id

WHERE fixtures.season = '2018-2019' AND fixtures.series = 'serie-a'

ORDER BY fixtures.date ASC

When I try to add a second JOIN to the query, it returns the error message that I have a duplicate entry for teams.team_id which I understand to some degree, however, not finding a way around that. Been juggling around with UNION ALL but that one does not bring me even closer though it should be.

EDIT: I'm (trying) to output results via PDO in PHP 7.

This topic has been closed for replies.