-- Create a report showing employee orders using Aliases.

SELECT e.EmployeeID, e.FirstName, e.LastName,
    o.OrderID, o.OrderDate
FROM Employees e JOIN Orders o ON
    (e.EmployeeID = o.EmployeeID)
ORDER BY o.OrderDate;