Step 1. Modify the saved query Query Basics.LCQ

LCE230 - Join Query

1.  Open the query Query Basics.LCQ which you have saved in a previous exercise.

     This query is over the Employee file and displays the Department code, Employee Identification, Surname, Given Names and Annual Salary.

a.  From the toolbar select the File menu and then choose the Open command. Alternatively, you could select the Open an existing query icon from the toolbar.

b.  Select to open Query Basics.LCQ

3.  Add the following fields to your query:

• Department Description from the Department file (after Department code)

Hint: Double click on the secondary file to expand it and select the field(s) you require.