How to Join Three Tables in MySQL to Display Specific Results?

Joining Three Tables Using MySQL

To join three tables and display the results in a specific format, follow these steps:

Steps for Joining Student, Course, and Bridge Tables:

1. Start with the ANSI-standard SQL syntax for joining tables:

   SELECT s.name AS Student, c.name AS Course
   FROM student s
   INNER JOIN bridge b ON s.id = b.sid
   INNER JOIN course c ON b.cid = c.id

   Copy after login

2. This query will correctly join the tables and display the required result:

   | Student | Course |
   |---|---|
   | ahmed | physic |
   | ahmed | maths |
   | ahmed | computer |
   | ahmed | chemistry |
   | ali | physic |
   | ali | maths |
   | john | computer |
   | john | chemistry |
   | king | physic |
   | king | maths |

   Copy after login

Steps for Joining employee and manage Tables:

1. Use the following query to join the employee and manage tables:

   SELECT e1.name AS Manager, e2.name AS Staff
   FROM employee e1
   INNER JOIN manage m ON e1.id = m.mid
   INNER JOIN employee e2 ON m.eid = e2.id

   Copy after login

2. This query will return the desired result:

   | Manager | Staff |
   |---|---|
   | ali | king |
   | ali | mak |
   | mak | sam |
   | sam | jon |

   Copy after login

The above is the detailed content of How to Join Three Tables in MySQL to Display Specific Results?. For more information, please follow other related articles on the PHP Chinese website!