Viewing 2 posts - 1 through 3 (of 3 total)
thanks, Antares686.
it worked!
xmash999
quote:Try thisUPDATE cdSET TotalPaidIn = TotalPaidIn + cp.TotRec, BalanceOnHand = BalanceOnHand + cp.TotRecFROM casedata cdINNER JOIN(SELECT CaseNumber, SUM(ReceiptAmount)...
quote:
UPDATE cd
SET TotalPaidIn = TotalPaidIn + cp.TotRec, BalanceOnHand = BalanceOnHand + cp.TotRec
FROM casedata cd
INNER JOIN
(SELECT CaseNumber, SUM(ReceiptAmount)...
March 4, 2002 at 8:05 am
#424833
sorry for the typo in the topic field!
March 1, 2002 at 10:22 am
#424717