LCE240 - Linked Queries
1. Click on the Execute (run) the current query icon 
from the toolbar.
Alternatively, from the toolbar select the Query menu and then choose the Execute command, or use this command's accelerator keys (Ctrl + E)
2. In the Results window, select the first department: 100/Accounting.
3. To execute the linked query, select the Results menu and choose the Linked Queries command. This will display a drop down menu.
Alternatively, right mouse-click on the selected item and choose the Linked Queries command.
4. Select the xEmployee by xDepartment and xEmployID command from the drop down menu. This will execute the secondary query using the department 100/Accounting as its selection criteria.
5. A new Results window is displayed to show you the list of departments.
6. In the Results window, select an Employee.
7. To execute the linked query, select the Results menu and choose the Linked Queries command. This will display a drop down menu.
Alternatively, right mouse-click on the selected item and choose the Linked Queries command.
8. Select the Notes by Employee command from the drop down menu. This will execute the linked query using the Employee as its selection criteria.
9. Cascade or Tile your windows to see all Results windows.
Hint: Select the Window menu to find these options.
10. Try a few more drill down paths for the same department, or start with another department.
11. Close the query and result windows without saving.
Do not disconnect from this host.
