- On the Merge dialog box, click on INPUT.
-
Click on expert options.
Merge > Input > Expert Options
One or more optional Where Clauses may be entered on this screen. Each Where Clause entered is applied only to the table currently selected on the screen.
-
On this screen, select:
- Select table to associate WHERE clause with — Select the table to associate an optional SQL Where Clause with.
- Optional WHERE clause text — Enter the optional SQL Where Clause text to be associated with the selected table, restricting the selected rows. Do not include the word “WHERE” at the beginning of the text. It will be added automatically.