Adding a Select statement to the Query field

You can create a query by entering a SELECT statement into the Query field. Any valid SELECT statement based on the underlying database system and schema is allowed. No delimiting character to mark the end of the statement is required, for example:

SELECT * FROM CUSTOMERS
SELECT A.CU_NO, A.CU_NAME, A.CU_CITY, B.SA_ORDERDATE, B.SA_TOTAL
FROM CUSTOMERS A, SALES B
WHERE A.CU_NO = B.CU_ID
ORDER BY A.CU_NO

For database schema lookups, click Database Lookup.

The SELECT statement must be compliant with the SQL language supported by the connected database system. Be especially aware of differences regarding quote characters, date functions, and expressions. It is good practice to use the SQL 92 ANSI standard for queries compatible between different database systems.

Using Query Designer

Click Query Designer to open the Query Designer. To learn more about this tool, see “Query designer”.

Validating a query

Click Execute Query to run the query.