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.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
