title: Joining tables containing comma delimited values
body: <p>I have three excel sheet I push them into tables in SQL server and I need to join these table. However, I believe - as I have tried already - normal join wouldn't work. I have programming background but not that much with SQL.</p>
  
  <pre><code>Table1
  
  ID  Data_column reference_number
  1   some data   1528,ss-456
  2   some data   9523
  3   some data   ss-952
  4   some data   null
  
  Table2 
  
  ID      Data_column
  ss-456  some data
  ss-952  some data
  
  
  Table3 
  
  ID      Data_column
  1528    some data
  9523    some data
  </code></pre>
  
  <p>In the case below How I will be able to join this raw on both table.</p>
  
  <pre><code>Table1
  
  ID  Data_column reference_number
  1   some data   1528,ss-456
  </code></pre>