Contents
About this Guide
A quick start to AQT
Introduction to AQT
Getting help
Shortcut keys
Signing on to a Database
Configuring a Database Connection
Displaying information about your database
Displaying Data
Finding Data in a Table
Query Builder
Features of the Query Builder
GUI Query Builder - GUI Tab
Running your Query
GUI Query Builder - Table / Joins Tab
GUI Query Builder - Columns Tab
GUI Query Builder - Where Tab
Build a Where Clause
Building an IN clause
Building a SubSelect clause
Building a Correlated SubSelect clause
Having Statement
Visual Where
Union Queries
Query Builder - Union tab
Query Builder - Statement Options tab
Query Builder - Other tab
GUI Query Builder - Options Tab
WITH Statements
User-defined relationships
Understanding Foreign Keys
Running SQL
Running AQT as an unattended batch job
Amending Data
Exporting Data
Charting
Summarizing your Data
Merge Table
Loading Data
Comparing Data
Administration Component
System Monitor
Save Sessions
Options
Technical Notes on Options
AQT scripting
Technical information
FAQs
Troubleshooting
Index