More SQL 1

[ivalum21]

Okay...I have a list of customer orders with their totals. They are grouped by the items that were bought, so if you bought a car, that is one record, and if you also bought a truck, that is another record with the same order number. How do i group those two records to display the total amount of the one order?

 

[r937]

select customer
     , sum(itemamount) as orderamount
  from yourtable
group
    by customer

rudy

http://r937.com/

SQL Consulting