title: Joining three tables using MySQL
body: <p>I have three tables named</p>
  
  <pre><code>**Student Table**
  -------------
  id    name
  -------------
  1     ali
  2     ahmed
  3     john
  4     king
  
  **Course Table**
  -------------
  id    name
  -------------
  1     physic
  2     maths
  3     computer
  4     chemistry
  
  **Bridge**
  -------------
  sid    cid
  -------------
  1     1
  1     2
  1     3
  1     4
  2     1
  2     2
  3     3
  3     4
  4     1
  4     2
  </code></pre>
  
  <p>Now to show the student name with the course name which he had studied like,</p>
  
  <pre><code>**Result**
  ---------------------------
  Student        Course
  ---------------------------
  ahmed         physic
  ahmed         maths
  ahmed         computer
  ahmed         chemistry
  ali           physic
  ali           maths
  john          computer
  john          chemistry
  king          physic
  king          maths
  </code></pre>
  
  <p>I build following query</p>
  
  <pre><code>select s.name as Student, c.name as Course from student s, course c join bridge b on c.id = b.cid order by s.name
  </code></pre>
  
  <p>But it does not return the required result...</p>
  
  <p>And what would be for normalized form, if I want to find who is manager over other:</p>
  
  <pre><code>**employee**
  -------------------
  id        name
  -------------------
  1         ali
  2         king
  3         mak
  4         sam
  5         jon
  
  **manage**
  --------------
  mid      eid
  --------------
  1         2
  1         3
  3         4
  4         5
  </code></pre>
  
  <p>And wants to get this result:</p>
  
  <pre><code>**result**
  --------------------
  Manager      Staff
  --------------------
  ali          king
  ali          mak
  mak          sam
  sam          jon
  </code></pre>