SQL Inner Join – How to Join 3 Tables in SQL and MySQL

PHOTO EMBED

Tue Nov 08 2022 12:39:12 GMT+0000 (Coordinated Universal Time)

Saved by @rajkumar515 #mysql

SELECT
  teams.team_name AS team_name,
  projects.project_name AS project_name
FROM TABLE teams
INNER JOIN matches
  ON teams.id = matches.team_id
INNER JOIN matches
  ON matches.project_id = projects.id
ORDER BY teams.id;
content_copyCOPY

https://www.freecodecamp.org/news/sql-inner-join-how-to-join-3-tables-in-sql-and-mysql/