Creating Queries
Adding filters
Filter Selection
You can add filters to your query to further refine your search criteria by following these steps:
- Select a column from the drop-down list.
- Select an operation.
- Select a value.
- Repeat the process to add more filters. You can select the logical operator
AND or OR from the first column to connect your query filters.
Use AND if you want data pulled out of the tables only if both sets of criteria are met.
Use OR if either or both sets of criteria are met.
Optionally, you can create more complex filters by selecting
parentheses to add to any section of the filter.
Limit Records Processed
You can limit the number of observations that are read from a table by typing the maximum number of
records you'd like returned in the Limit records processed to field.
Edit SQL
Users who are proficient in SQL can edit the SQL statement directly by clicking Edit SQL.
Incorrect editing
of the SQL statement will result in errors and loss of the query.
Save
If you want to save your query at this point, refer to
Saving Queries.
Next
After you select your filters, you can view your query or
format your data.