Please refer this example of JOIN with ORDER BY
SELECT emloyees.FirstName , orders.OrderId
From Employees emloyees
INNER JOIN Orders orders ON emloyees.EmployeeId = orders.EmployeeId
INNER JOIN Customers customers ON customers.CustomerId = orders.CustomerId
WHERE customers.City = 'Aachen'
ORDER BY FirstName ASC
FirstName OrderId
Janet 10391
Laura 11036
Margaret 10363
Nancy 10825
Nancy 11067
Robert 10797