MySQL Join issue
- by mouthpiec
Hi,
I have the following tables:
--table sportactivity--
sport_activity_id, home_team_fk, away_team_fk, competition_id_fk, date, time
(tuple example) - 1, 33, 41, 5, 2010-04-14, 05:40:00
--table teams--
team_id, team_name
(tuple example) - 1, Algeria
Now I have the following SQL statment that I use to extract Team A vs Team B
SELECT…