Hi,

--- In firebird-support@yahoogroups.com, "ibrahim bulut"
<i.bulut@i...> wrote:

>
> update customers c
> set
> totalorders = (select sum(Orders.TotalOrders) from orders orders
> where orders.CustomerID = c.id)
> where c.id = :id

this query is OK for one record, but does exsist any solution to
repeat query n time (n is a nuber of records in the orders table) in
one SQL statment.

Thanks

>
>
> ----- Original Message -----
> From: "majstoru" <majstoru@y...>
> To: <firebird-support@yahoogroups.com>
> Sent: Tuesday, December 27, 2005 12:48 AM
> Subject: [firebird-support] Small Update SQL trick (problem)
>
>
> > 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...
> >
> >
> >
> >
> >
> >
> >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Visit http://firebird.sourceforge.net and click the Resources

item

> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> > __________ NOD32 1.1340 (20051226) Information __________
> >
> > This message was checked by NOD32 antivirus system.
> > http://www.eset.com
> >
> >
>