Do one or more of the following:
- Edit the query code in the
Customized Query Pair window; then click
Compare. Results are shown on the
Results tab.
- Build a WHERE or an ORDER BY clause into the SELECT statement:
- Use the fields and controls in the
WHERE/ORDER BY in SELECT group to construct the clause. When you click
> or
<, HCOSS updates the code in the
Customized Query Pair window.
- Click
Compare. Results are shown on the
Results tab.
- On the
Customize Compare Data tab, click
Save All to save the changes.
Note: HCOSS does not save manual changes made to code in the
Customized Query Pair window.