Question: Create a SQL query based on tblTransaction and tblEmployees that will display all the fields from tblTransaction and the FirstName and LastName fields from tblEmployees.

 Create a SQL query based on tblTransaction and tblEmployees that will display all the fields from tblTransaction and the FirstName and LastName fields from tblEmployees. Use a join to include all employees, regardless if they have sold any products. Sort in ascending order by the employee's first name and last name. Save your query as qryEmp Transaction_initialLastname, and then close the query. k. (Optional) Create a SQL subquery that will list the total sales volume for products sold in the first quarter of 2020. Name the totaled Quantity field Quarter1Volume. Save the query as qryQur1Sales_initialLastname. I. Save and submit ACCESS file as directed by your instructor.

Additional comments: Please give me the sql code and do these steps step by step 

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Create a SQL query to display all fields from tblTransaction and the FirstName and LastName fields f... View full answer

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 Databases Questions!