Lynn Pettis (4/20/2014)

---

Let me get this straight, you want the data in each column sorted in ascending order independent of the relationship of the data.

Please explain the rational for this...

Lynn Pettis (4/20/2014)

---

Does this return what you expect?

Select (e.FirstName + ' ' + e.LastName) as EmployeeName,

c.CustomerID,

o.OrderID,

o.OrderDate,

SUM((r.UnitPrice * r.Quantity) - (r.UnitPrice * r.Quantity * r.Discount)) as OrderAmount

FROM Orders o

Inner Join...