Subject Re: [ib-support] how to perform update with aggregate subselect ?
Author Andrew Guts
Louis Kleiman wrote:

>In my apps, IDs like this are always integers > 0. I often have to add
>what I call hints to queries like this that don't want to use the
>primary key without a little nudging:
>update table1
> set total = (select sum(Quantity) from table2 where table2.CustomerID
>= table1.CustomerID and table2.CustomerID > 0)
>Maybe it works in your case, maybe not...
>Louis Kleiman
>SSTMS, Inc.
Oops, sorry. I've missed something. Now I've got it. Nice idea. Thank
you very much.