Editing the WHERE Clause

When you use the Column Selection window (Figure 78) to select a column or columns for the WHERE clause, the selected columns appear in the Where text box. The =? symbols indicate where you must provide match conditions. Figure 81 shows the result when you choose zipcode and customer_num from the customer table.

To edit the WHERE clause

Select =? and change it to the desired match condition.
For example, the Where text box in Figure 81 contains the following text:
```
customer.zipcode =? and customer.customer_num =?
```
You must change both occurrences of =? to valid match conditions. You might change the text as follows:
```
customer.zipcode > 50000 and 
   customer.customer_num > 150
```
For a full description of match conditions, see Appendix D. Match Condition Operators and Characters.
Check the comparison operators.
When you select multiple columns from the Column Selection window, ipload inserts and into the expression between each column. You might need to change and to or.