title: How can I perform the same query on multiple tables in Redshift
body: <p>I'm working in SQL Workbench in Redshift. We have daily event tables for customer accounts, the same format each day just with updated info. There are currently 300+ tables. For a simple example, I would like to extract the top 10 rows from each table and place them in 1 table.</p>
  <p>Table name format is Events_001, Events_002, etc. Typical values are Customer_ID and Balance.</p>
  <p>Redshift does not appear to support declare variables, so I'm a bit stuck.</p>