title: MySQL SELECT multiple tables at once
body: <p><img src="https://i.imgur.com/mplRmiv.png" alt=""></p>
  
  <p>If I need all rows from multiple <strong>completely unrelated</strong> tables, is it more efficient to run a single <code>SELECT</code> query?</p>
  
  <p>So the result returned could be like:</p>
  
  <pre><code>[{ table: "table1", id: 1 }, 
   { table: "table1", id: 2 },
   { table: "table2", code: 1 }]
  </code></pre>
  
  <p>Or would it be just as efficient as running separate <code>SELECT</code> query for each of the table?</p>