title: select records where words from a table appear in a field on a different table
body: <p>I have 2 tables: 1 with a list of messages in a field and another table with 1 column with a list of keywords. I need to select all records where one or more of the keywords appear in the <code>MessageText</code> field.</p>
  
  <p>This is what I have so far but doesn't work:</p>
  
  <pre><code>SELECT MessageID, MessageText
  FROM Messages
  WHERE MessageText LIKE (
       SELECT  '%'+Keyword+'%' 
       FROM keywords_table)
  </code></pre>