The process of building a query using OpenESQL includes at least some and potentially all of the following steps:
- Determine which table you want to query
- Select the type of query to create
- Select a column or columns to query
- Specify search criteria to limit returned data
- Dictate the order in which data is retrieved and displayed
- Specify table joins
The following sections provide information about this process.