--- In firebird-support@yahoogroups.com, "bill2janesoft@..."
<bill2janesoft@...> wrote:

>
> Hello,
> I think that this is a fairly common job, but I don't know how to do

it in one sql.

> eg, in master/detail invoice tables
> table master has 2 fields (key1, tot)
> table detail has 3 fields (key1, linenum, subtot)
>
> I want to update all records in master so that
> each tot = sum(subtot) for master.key1=detail.key1
>

Maybe a view would be the solution
CREATE VIEW MasterView AS
SELECT key1, SUM( subtot )
FROM detail
GROUP BY key1

regards / liebe Grüße aus einem sonnigen Wien
Andre

> thanks in advance
>
> --
> regards,
> bill
>