title: Select multiple values from a column based on a certain value from another column
body: <p>I have three mysql tables as "Courses", "Modules", and "Course_Managements" as following...</p>
  
  <p>"Modules" Table...</p>
  
  <pre><code>Module_id   Module_title
    1         Accounting
    2         Management
    3         Marketing
  </code></pre>
  
  <p>"Courses" Table...</p>
  
  <pre><code>Course_id   Course_title
    1          CIMA
    2          aat
    3          SLIM
    4          MBA
  </code></pre>
  
  <p>"Course_Managements" Table...</p>
  
  <pre><code> CM_id   Module_id  Course_id
    1           1         1
    2           1         2
    3           2         1
    4           2         4
    5           3         3
    6           3         4
  </code></pre>
  
  <p>I want to assign SQL Query, by selecting a Course ID (Let's say '1') then the available Module_ids have to be listed as... '1' and '2'</p>
  
  <p>I'm trying to develop an interface by which a User can select a Course then he / she  can view the Modules under it...</p>
  
  <p>Could anyone suggest a SQL Query to do it..?</p>