title: How to do a MySQL select query on two tables linked by another table
body: <p>Suppose I have a table whose function is specifically to link two other tables in terms of OOP.</p>
  
  <p>Suppose that I have two tables: one for person's name and another one for phone numbers:</p>
  
  <pre><code>Table 1:
  id   person's name
  1    John
  2    Smith
  
  Table 2:
  id   Phone number
  5     23424224
  6      23424242
  </code></pre>
  
  <p>And then I have a third table that links the person and their respective phone numbers:</p>
  
  <pre><code>Table 3:
  id    person-id    phone-number-id
  1         1           5
  2         2           6
  </code></pre>
  
  <p>Hence John has phone number 23424224 and Smith has phone number 23424242.</p>
  
  <p>And I want to run an SQL query to fetch all persons from Table 1 whose phone number start with, let's say, (234).</p>
  
  <p>How would I go about linking the select queries within this table structure...what query would I run?</p>