hi all..

let say i have 2 table named customer and sales

Customer
Id Name Date ................
------------------------------------------------
5 ABC 1/1/03
6 DEF 1/5/03
7 GHI 1/8/03
8 JKL 1/10/03


Sales
Customer_Id Product Quantity Amout
--------------------------------------------------------
5 ABC 1 10.00
5 ABC 2 20.00
5 ABC 3 30.00
6 ABC 4 40.00
6 ABC 6 50.00
7 ABC 7 60.00
8 ABC 8 70.00
8 ABC 9 80.00


let's say now i wan to select data Between 1/1/03 and 1/5/03
wat data field i wan to retrive is

Customer.Id Customer.Name Total Sales (Total row in Sales),
Total Quantity, and Amount

so.. my data should be
Id Name Total_Sales Quantity Amount
--------------------------------------------------------
5 ABC 3 6 60.00
6 DEF 2 10 90.00

so.. anyone can help me how to write those SQL coding?