title: SELECT from multiple tables same data and ignore other columns
body: <p>Im trying to select rows from multiple table who share some common data</p>
  
  <p>Common data from table1 and table2 are: <code>name</code>, <code>content</code> BUT <code>table2</code> has <code>uname</code> instead of <code>name</code> but they are same</p>
  
  <p><code>table2</code> has an extra columns for <code>date</code> and <code>U</code> which i want to ignore but search by <code>U</code>
  <code>table1</code> has extra column called <code>country</code> which i m ignoring</p>
  
  <p>Actually im running 2 queries instead of 1</p>
  
  <p>My two queries I'm running are:</p>
  
  <pre><code>SELECT DISTINCT name, content FROM table1 WHERE name LIKE '%foo%'
  SELECT DISTINCT uname, content, u FROM table2 WHERE uname LIKE '%foo%' AND U = 1
  </code></pre>
  
  <p>I have tried something like:</p>
  
  <pre><code>SELECT DISTINCT t1.*, t2.* FROM table1 t1, table2 t2 WHERE t1.name LIKE '%foo%' AND t2.uname LIKE '%foo%' AND t2.U = 1
  </code></pre>
  
  <p>But it doesn't work as I want and I doubt if its good when talking performancewise .</p>
  
  <p>I would appreciate your help</p>