Edit the Table Structure

Getting Started #

After you download a Table, you can use the Edit Query button on the ribbon to modify the structure.

The structures of all tables are SQL Statements broken down into the following sections.

Select
- Use to choose which columns you want to see in the download.
- Columns not belonging to the main table (From) must have an Alias that starts with an asterisk. That tells the import, update and other actions to ignore the column since it’s not part of the main table.
From
- Use to choose the main table of your Table.
Join
- Use to join other tables so you can get additional columns for display or filtering.
Where
- Use to filter the data with hard coded values or create your own parameters.
Group By
- Use to set the sort order of the records.

The topics below walk you through changing the various sections of a report.

Core 4

Advanced Topics