Question

j. 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 qryEmpTransaction_initialLastname, and then close the query. Feilds from tbl Transaction are TransactionID, CustomerID, EMployeeID, TransactionDate, MethodOfPayment

Feilds from tbl Employees are EmployeeID, FirstName, LastName, Address, City, State, Phone, Full time

Answer 1

SELECT tblEmployees.FirstName, tblEmployees.LastName,tblTransaction.TransactionID,tblTransaction.CustomerID, tblTransaction.EMployeeID,tblTransaction.TransactionDate, tblTransaction.MethodOfPayment
FROM tblEmployees
LEFT JOIN tblTransaction
ON tblEmployees.EmployeeID= tblTransaction.EMployeeID
ORDER BY tblEmployees.FirstName ASC, tblEmployees.LastName ASC;