Creating a Join Index for Department and Employee

This example creates a join between Departments table and Employees table, using equivalent values in columns from the two tables. Follow these steps to create a joined index called dept_emp_jdx.

1. Right-click Join Indexes, point to New, choose Join Index.
2. Type the name of your new join index, dept_emp_jdx, in the Name box.
3. In the Join Type dropdown box, select ON. The ON clause is required to join equivalent columns with the same name (dept_id) from two tables.
4. Choose Departments for the left table.
5. Choose Employees for the right table.
6. Click Next.
7. In the Choose Index Columns dialog, select the desired Left Table column, DepartmentID and the Right Table column DepartmentID.
8. Click Add. After you add the two columns, they appear in the Join Index Columns box as GROUP0.Departments.DepartmentID=GROUP0.employees.DepartmentID. (You may have to scroll to read the entire join.)
9. Click Next.
10. On the Add Comment screen, type the following to describes the join index, Join index for Departments and Employees. Click Finish.
11. The dept_emp_jdx join index appears in the Join Indexes folder.