title: PostgreSQL: Joining Tables Based on Searched Concatenated Strings
body: <p>I'm not sure how to write a join clause that takes a value from table 1, then searches a string in table 2 to see if they match. Sound confusing?</p>
  
  <p>Here's the actual example I'm working with. </p>
  
  <p><strong>Table 1</strong></p>
  
  <pre><code>Customer_Id   Concat_Phone_Numbers
  1                     8888888888;1111111111
  </code></pre>
  
  <p><strong>Table 2</strong></p>
  
  <pre><code>Caller         Callee      Calldate
  1111111111     3333333333  1/1/1900
  </code></pre>
  
  <p>I want to create a table that looks like this:</p>
  
  <p><strong>Desired Table</strong></p>
  
  <pre><code>Customer_Id  Calldate
  1            1/1/1900
  </code></pre>
  
  <p>I'm lost when it comes to writing the join clause so that the entire list in Table 1's second column is searched for a matching phone number/entry.</p>
  
  <p>Thank you in advance for your help! (PS it's my first time asking a question!)</p>
  
  <p>Edit:: </p>
  
  <p>Here's where I'm at now</p>
  
  <pre><code>Select 
  * 
  from table1
  left join table2 
  on ??????????????????
  </code></pre>