>>
>>
>>Update TableA Set Field1 = ST.Sum_TOT
>>FROM TableA INNER JOIN (select sum(FldA+FldB) as Sum_Tot from TableB group b y FldC) ST
>>ON TableA.FieldC = ST.FieldC
>
>A follow up question, if I may, please. The above SQL Update will update only those records in table TableA that have child records in TableB, correct? So if I wanted to update ALL records in TableA, would it be correct to change JOIN with LEFT JOIN then? And then to do NVL(ST.SUM_TOT,0) instead of just ST.SUM?
That sounds right to me.
Tamar