title: Select items like records from a column in another table
body: <p>I have a table (foo) with a large number of several records and I only want to select those that are like one of the records in a field in another table (foo2)</p>
  
  <p>If I do a SELECT query with an inner join</p>
  
  <pre><code>SELECT pst_qty AS [QTY]
    ,[MFGPN]
    ,[mfg_name] AS [MANUFACTURER]
    ,description
    ,sup_id
    FROM [foo]
    INNER JOIN [foo2]
    ON [foo].[MFGPN] = [foo2].TestString
  </code></pre>
  
  <p>afaik I would only get records where foo.field1=foo2.field1.   I can't seem to use ON foo.field1 LIKE foo2.field2 to select records like the fields in foo2.  How would I go about selecting the records that are like the records from a column in a different table?</p>