title: Select from all tables
body: <p>I have a lot of tables in my data base all with same structure. I want to select from all tables without having to list them all like so:</p>
  
  <pre><code>SELECT name FROM table1,table2,table3,table4
  </code></pre>
  
  <p>And I tried but this doesn't work:</p>
  
  <pre><code>SELECT name FROM *
  </code></pre>
  
  <p>Is there a way to select all tables in a database without listing each table in the query?</p>