I'm pretty new to SQL and I have 12 tables with the same schema containing the same types of data from 12 months, and I need to merge them all into one big table. How can I do this in BigQuery using SQL?
I have tried creating a temp table, which is all well and good, but I want to be able to come back to it later.