title: Querying across multiple tables with identical schemas
body: <p>I'm trying to run the same query over multiple tables in my Postgres database, that all have the same schema. </p>
  
  <p>This question: <a href="https://stackoverflow.com/questions/12095109/select-from-multiple-tables-without-a-join">Select from multiple tables without a join?</a> 
  shows that this is possible, however they are hard-coding the set of tables. </p>
  
  <p>I have another query that returns the five specific tables I would like my main query to run on. How can I go about using the result of this with the UNION approach?</p>
  
  <p>In short, I want my query to see the five specific tables (determined by the outcome of another query) as one large table when it runs the query.</p>
  
  <p>I understand that in many cases similar to my scenario you'd simply just want to merge the tables. I can not do this. </p>