Create a SQL query based on tblTransaction and tblEmployees that will display all the fields from tblTransaction
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. 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
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last