title: MySQL Join and find in multiple tables
body: <p>I know there alot of Questions regarding this matter, however i cant make sense as they seem to be direct answers with no great understanding to me.</p>
  
  <p>This is what I want to do:</p>
  
  <p>I have three tables: <code>fusers</code>, <code>tusers</code>, <code>lusers</code>. They
  all contain the row: <code>email</code></p>
  
  <p>I want to combine the three tables, and find out if a user submitted variable <code>$email</code> already exists in the <code>email</code> row.</p>
  
  <p>I know that using inner joins and possibly union all will work, but for the life of me, i can't find a decent tutorial or example which i can learn from.</p>
  
  <p>Anyone?</p>