Yup:

SELECT LastName, FirstName, StatusCode, TimeCreated, CallID, AssociateID
FROM Customers
INNER JOIN CustStatus ON Customers.CallID = CustStatus.CallID
ORDER BY 6, 1, 2, 4 DESC

becomes

SELECT LastName, FirstName, StatusCode, Max(TimeCreated), CallID, AssociateID
FROM Customers
INNER JOIN CustStatus ON Custmers.CallID = CustStatus.CallID
GROUP BY LastName, FirstName, StatusCode, TimeCreated, CallID, AssociateID