title: sql query join two tables on one table column equals to some columns in another table
body: <p>I have two tables:</p>
  <p>Customers phones : contains first name, last name and phone:
  <a href="https://i.stack.imgur.com/8QXFj.png" rel="nofollow noreferrer">phones</a></p>
  <p>Customers Email: contains full name (first name + last name) and email.
  <a href="https://i.stack.imgur.com/1gexj.png" rel="nofollow noreferrer">email</a></p>
  <p>I have to join them in order to get this result:</p>
  <p><a href="https://i.stack.imgur.com/sNnvp.png" rel="nofollow noreferrer">result</a></p>
  <p>My query:</p>
  <pre><code>select *, email 
  from customersPhones 
  join customersEmail on ??
  </code></pre>
  <p>How can I do it?</p>