>>>
>>>
>>>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?
>
>Yes, you should change INNER TO LEFT JOIN.
>A few typos here:
>
>Update TableA Set Field1 = ST.Sum_TOT
>FROM TableA
>INNER JOIN (select FieldC, /* Here, you should include FieldC in the query*/ sum(FldA+FldB) as Sum_Tot
> from TableB
> group by /*Here b y must be BY and FldC must be FieldC*/ FieldC) ST
>ON TableA.FieldC = ST.FieldC
>
>:-)
Thank you. Yes, I did pick up that the FieldC should have been included. I appreciate your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
