Hi,

I have a small problem, maybe is not a problem, but an expret trick.
I'm using Firebird 2 and I have two tables fex: Customers, Orders! I
would like to write a SQL statment to update Customers (field
TotalOrders) from table Orders.
Something like:
UPDATE Customers
SET TotalOrders = SUM(Orders.TotalOrders)
// begin of the problem
The continue of this SQL must update all customers form table orders,
something like FOR DO (in delphi).
Important: I need this solution like SQL statment no StoredProcedure!

Thanks for ALL...