The Visual SQL Editor enables you to construct, edit, and execute SQL queries graphically. The Visual SQL Editor supports a subset of SQL92.
You can manipulate the following types of SQL queries in the diagram pane and grid pane:
SELECT statements: SELECT...FROM...WHERE...
JOINS: OUTER, INNER, CROSS, NATURAL
Search conditions consisting of comparison predicates combined with multiple ANDs and ORs
Aggregate functions: AVG, COUNT, MAX, MIN, SUM
Correlation names ("table aliases")
Derived column names ("column aliases") based on individual columns
GROUP BY
ORDER BY
Predicates: IN, LIKE
SQL parameters (conditions like WHERE name=?)
You must type the following conditions in the SQL pane. These conditions
have no graphical representation, but you can still execute the queries.
Predicates: BETWEEN, NULL, IN, LIKE, EXISTS
Search conditions consisting of comparison predicates combined with
multiple ORs
Note: When specifying SQL identifiers like column names, table names, index names, and view names, if you use characters outside of the standard SQL identifier characters of A-Z, a-z, 0-9 and _, then you must quote the identifier.