title: Query multiple not related tables in SQL
body: <p>I have more than 50 tables that are not related but all of them have a "Name" field, I want to query "John" and get all Johns in the different tables and store each row in an array (Javascript) for example:</p>
  
  <pre><code>arr['table1']="results if any"
  arr["table2"]="results if any".
  </code></pre>
  
  <p>What I'm doing right now is a for loop for each table: <br>
   <code>SELECT * from tablesNameArray[i] WHERE name="John",</code> <BR>
  but I'm really wondering if there is any other better or "more" correct way to do it.</p>
  
  <p>Thanks </p>