QMF offers
different query methods depending on the user's level of SQL knowledge.
The query diagram designer in QMF for Workstation allows
users to develop complex queries graphically, eliminating the need
to write SQL. Users simply drag and drop database tables (real or
virtual) and wire columns together to form joins between them, as
shown in the figure below. Figure 1. The query diagram designer in QMF for Workstation
Columns for display can be selected by double-clicking
table fields; the companion column detail area allows users to select
aggregations and ordering options, as well as row filters. Users can
display the automatically-generated SQL at any time and move between
the diagram, SQL, and prompted query views, or develop the query using
all three types of views.