Sum of 2 columns with values returns zero

[sonaliak]

I tried this it still doesn't work..

Update mwebtemp
Set Temp_amount2= (SELECT Sum(Sched_Amount)+ (NVL(Temp_Amount1,0.0))
FROM mwebSchedule
WHERE Sched_Work_ID in (select Work_ID from mwebWork where Work_Entity_Type in(4, 30)
)
and Sched_Res_ID=Temp_Ent_ID and Sched_Category = 4500
GROUP BY Temp_Amount1 )
Where Temp_Trancode = inTrancode;

I took out some portion of where clause to make it simpler..

I also tried...this one doesn't work either.. What is wrong in my query ?


Update mwebtemp
Set Temp_amount2= (SELECT SUM(Sum(Sched_Amount)+ (NVL(Temp_Amount1,0.0)))
FROM mwebSchedule
WHERE Sched_Work_ID in (select Work_ID from mwebWork where Work_Entity_Type in(4, 30)
)
and Sched_Res_ID=Temp_Ent_ID and Sched_Category = 4500
GROUP BY Temp_Amount1 )
Where Temp_Trancode = inTrancode;