title: Query same field from two different tables MYSQL
body: <p>I've been having an issue trying to query 3 tables and 2 with the same field. Using php and mysql </p>
  
  <p>example</p>
  
  <p>TableA
  TableB
  TableC</p>
  
  <p>keyword in the query would be a search term.</p>
  
  <pre><code>SELECT 
     title 
  FROM TableA as A 
  LEFT JOIN TableC as C 
     ON TableA.id=TableC.id 
  WHERE 1 
     AND TableC.private='0' 
     AND ( 
          title LIKE '".$keyword."%' 
       OR title LIKE '%".$keyword."%' 
       OR title LIKE '%".$keyword."' 
       OR title = '".$keyword."' 
     )
  </code></pre>
  
  <p>The problem I'm having is I ALSO need to simultaneously search TableB for title and do a match based on the same keyword. How do I incorporate TableB title field into the query? </p>
  
  <p>So if there is say TableA with title=America and TableB with title=American it will display both results from both tables since it would match the LIKE query.</p>
  
  <p>Then with PHP show the result. If TableA or TableB matches show that result(s). And loop through the array etc.</p>
  
  <p>It has to be in a query because I'm using it for a search parameter. </p>
  
  <p>TIA</p>