title: SQL query from 2 table into one (is this done by using join?)
body: <p>I have a table called products, products has several fields, 2 of those are of importance in this question, column ID and column ProdDetail.</p>
  
  <p>I have another table lets call it table2. Table2 has an ID column and a Name column.</p>
  
  <p>I want to run an sql query which does the following:</p>
  
  <pre><code>insert into table3  products.ID and table2.ID 
  where products.ProdDetail CONTAINS table2.Name
  </code></pre>
  
  <p>I know that this code isn't valid sql statement. Also I can't use join because products.ProdDetail contains more data than just table2.name, so they are not exactly the same.</p>