title: What is the best way to join between two table which have coma seperated columns
body: <p>Table1 </p>
  
  <pre><code>ID        Name              Tags 
  ----------------------------------
  1        Customer1         Tag1,Tag5,Tag4 
  2        Customer2         Tag2,Tag6,Tag4,Tag11 
  3        Customer5         Tag6,Tag5,Tag10 
  </code></pre>
  
  <p>and Table2 </p>
  
  <pre><code>ID     Name             Tags 
  ----------------------------------
  1    Product1     Tag1,Tag10,Tag6 
  2    Product2     Tag2,Tag1,Tag5 
  3    Product5   Tag1,Tag2,Tag3 
  </code></pre>
  
  <p>what is the best way to join Table1 and Table2 with Tags column?</p>
  
  <p>It should look at the tags column which coma seperated  on table 2 for each coma seperated tag on the tags column in the table 1</p>
  
  <p>Note: Tables are not full-text indexed.</p>
  
  <p><img src="https://i.stack.imgur.com/OzXAP.png" alt="enter image description here"></p>