Filter
Top Products
CHAPTER 3 Managing the Database
DataWindow Designer User’s Guide 85
3 To create a join other than the equality join, click the join representation in
the workspace.
The Join dialog box displays:
4 Select the join operator you want from the Join dialog box.
If your DBMS supports outer joins, outer join options also display in the
Join dialog box. For example, in the preceding dialog box (which uses the
Employee and Department tables), you can choose to include rows from
the Employee table where there are no matching departments, or rows
from the Department table where there are no matching employees.
For more about outer joins, see “Using ANSI outer joins” on page 127.
Dropping a database
view
Dropping a database view removes its definition from the database.
❖ To drop a view:
1 In the Objects view, select the database view you want to drop.
2 Click the Drop Object button or select Drop View from the pop-up menu.
DataWindow Designer prompts you to confirm the drop, then generates a
DROP VIEW statement and submits it to the DBMS.