Filter
Top Products
Using SQL Select
122 DataWindow .NET
6 Limit the retrieved rows with WHERE, ORDER BY, GROUP BY, and
HAVING criteria, if appropriate.
For more information, see “Specifying selection, sorting, and grouping
criteria” on page 130.
7 If you want to eliminate duplicate rows, select Distinct from the Design
menu. This adds the
DISTINCT keyword to the SELECT statement.
8 Click the Return button on the PainterBar.
You return to the wizard to complete the definition of the DataWindow
object.
Selecting tables and views
After you have chosen SQL Select, the Select Tables dialog box displays in
front of the Table Layout view of the Select painter. What tables and views
display in the dialog box depends on the DBMS. For some DBMSs, all tables
and views display, whether or not you have authorization. Then, if you select a
table or view you are not authorized to access, the DBMS issues a message.
For ODBC databases, the tables and views that display depend on the driver for
the data source. Adaptive Server Anywhere does not restrict the display, so all
tables and views display, whether or not you have authorization.
❖ To select the tables and views:
• Do one of the following:
• Click the name of each table or view you want to open.
Each table you select is highlighted. (To deselect a table, click it
again.) Click the Open button to close the Select Tables dialog box.
• Double-click the name of each table or view you want to open.
Each object opens immediately behind the Select Tables dialog box.
Click the Cancel button to close the Select Tables dialog box.
Representations of the selected tables and views display. You can move or size
each table to fit the space as needed.