title: SQL Like value from another table and wildcharcters
body: <p>I have two tables, the value of NDC_10 for table test is a 10 digit code while the value of PRODUCTNDC in table product is a 8 digit code.  I am trying to select all of the rows in which the 8 digit code is inside the 10 digit code such as:
  0123456789 = 10 digits
  12345678 = 8 digits</p>
  
  <p>I have come up with something like this logically, but I do not know how to nest the 2 wild characters inside the search of the other table</p>
  
  <pre><code>select NDC_10
  FROM test, product
  WHERE (NDC_10 LIKE '_product.PRODUCTNDC_')
  </code></pre>