title: how to compare the column from another table in a same query
body: <p>I have two tables <code>td_excel</code> and <code>td_user</code>. I am using the following query to display records from the table <code>td_excel</code>. It have many columns but i comparing two columns <code>Pickup_Location</code> and <code>regional</code> it works perfectly,but i also want to compare the column <code>regional</code> from another table <code>td_user</code> in the same query is it possible?   </p>
  
  <pre><code>SELECT * 
  FROM 
      td_excel 
  where 
      `Pickup_Location` LIKE CONCAT(  '%',  `regional` ,  '%' ) OR 
      regional LIKE CONCAT(  '%',  `Pickup_Location` ,  '%' )
  </code></pre>