What is the Basic Structure of a Query Table?

In the beginning was a word, and the word was SELECT.

This initiates the query and what follows are all the fields you want to pull in from one or more tables. (formatted any way you like, but more on that later)

The FROM clause specifies which table(s) you’re drawing from. Adding to the FROM clause, you can join tables to draw from a larger pool of data. Here though, it’s just one table at a time.

After the FROM clause, you can filter out data using the WHERE clause (more on that later).

The UNION ALL keyword allows us to stack data vertically. It separates sub-queries from each other.