Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Formatting your data as a table, as we did above, will take care of this requirement. But basically you need to follow the structure of a database, where your data only includes column headings.

In this tutorial, I’ll show you how to create a date table when the internal default table isn’t adequate using Data Analysis Expressions.