Question: A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below.

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What must you change before you can reassign the DeptID field value for a particular employee in the query results?
Departments (DeptID, DeptName)
Employees (EmplD, Employeefirst, EmployeeLast, DeptID)
Add the DeptName field to the query.
Set DeptID as the primary key field in the Employees table.
Remowe the EmplD field from the query.
Replace the DeptiD field from the Departments table with the DeptiD field from the Employees table.
A query includes the DeptID and DeptName fields

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!