User guide

Creating view models
46 Data Integration with Sybase Avaki Studio
Step 6 Double-click the Join operator to open the Join Properties dialog.
Step 7 Select the Sort Merge Join algorithm, the Inner join type, and set the outer table to
getEmpGivenName.
Step 8 In the Columns area of the properties dialog, specify one or more pairs of columns
whose values will be tested for equality. Each pair must include one column from the
outer table and one from the inner table. In this case, the common column is called
DEPTNO in both tables. Click Add to add a column. Use the pull-down menus to
select DEPTNO for both the inner and outer columns
Step 9 Click OK.
For more information on the Join operator, see “Join” on page 154.