title: Compare two columns from different tables
body: <p>I know that this question has been asked several times and I did read them all.   However, my situation is little different I can still can't get the right results with my SQL statement below.</p>
  
  <p>I have two tables as shown below:</p>
  
  <pre><code>TABLE A
  ######################################################################
     |   ID   | IP_Address    | Username  | Comments
  ----------------------------------------------------------------------  
      1       128.        abc     travel to US
      2       127.        dzd     author
      3       127.        abc     It's not redundant at all. Not offering a single function
      4       124.        deb     I just lost laptop.  How do I report it?
  -----------------------------------------------------------------------
  
  
  
  TABLE B
  ######################################################################
     |   keywords     |
  ----------------------------------------------------------------------  
      author
      How do I report
  -----------------------------------------------------------------------
  </code></pre>
  
  <p>My intention is to pull out all records in TABLE A when the Comments column partially matches one of the keywords in TABLE B.</p>
  
  <p>Here is the query:</p>
  
  <pre><code>SELECT ID, IP_Address, UserName, Comments FROM TABLEA
  FULL JOIN TABLEB
  ON TABLEA.Comments LIKE TABLEB.Keywords
  WHERE TABLEA.Comments IS NOT NULL AND TABLEB.Keywords IS NOT NULL
  </code></pre>
  
  <p>It works but it only pulls out the EXACT match, not a part of the comments.<br>
  In my sample, it pulls out "author" record but not "I just lost laptop.  How do I report it?" record.  </p>
  
  <p>Is there a way to twist my query to meet my requirements?</p>
  
  <p>Thanks</p>
  
  <p>JPL</p>