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
Create a SQL query to display all fields from tblTransaction and the FirstName and LastName fields f... View full answer
Get step-by-step solutions from verified subject matter experts
