title: Compare 2 tables using match
body: <p>I have 2 tables <strong>table1</strong> and <strong>table2</strong>. Table1 consist of paragraph which is a news article including some company codes/names, while table2 is a dictionary consist of 2 columns which are company code and the company name. </p>
  
  <p>Using MYSQL FTS function MATCH i want to compare the article with all items/dictionary in table2 
  ( both of columns )</p>
  
  <pre><code>SELECT * FROM pyproject.table1 WHERE MATCH (Paragraph) against
  (SELECT * FROM pyproject.table2' with query expansion);
  </code></pre>
  
  <p>It seems to produce an error</p>
  
  <p>How to check whether the article matched with the dictionary, the data in <strong>table1</strong> will be selected and the <strong>company code</strong> column in <strong>table2</strong> is included/joined together with the data in <strong>table1</strong>.</p>
  
  <p>So if the article in <strong>table1</strong> consist of multiple company codes, it will be duplicated and added appropriate company codes</p>