Query Builder
You can use the query builder to create an advanced find.
Accessing the Query Builder
Click the Advanced tab.
Click the Query Builder icon.
How to Create an Advanced Find
You can type in your SQL query or click in the columns to help create the SQL query.
Manually Enter SQL
Click the SQL Text field and enter the SQL query
Using the Helper Columns
Double click the SQL syntax, table/views, or table/views columns you would like to use to add it to the SQL Text. Make sure to replace the placeholder text such as “<<ColumnList>>” with applicable column names.
See Advanced Functions for more information.