You have a database that contains information about all of the employees from your company. There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID.
Your supervisor wants to see a list of employees who are making over $25,000.00 and have a last name of a "Wilson". Describe how to accomplish this.

Question

You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID. 
 Your supervisor wants to see a list of employees who are making over $25,000.00 and have a last name of a "Wilson". Describe how to accomplish this.

Quizplus · Accepted Answer

The Answer of You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID. 
 Your supervisor wants to see a list of employees who are making over $25,000.00 and have a last name of a "Wilson". Describe how to accomplish this.

You Have a Database That Contains Information About All of the Employees