Just off the top of my head (I haven't tested it):
Code:
Select CustomerName, Sum(InvoiceAmt) As SubTotal From Customers Group By CustomerName