How can I do an update on multiple records. I have fields
CusOrderID and CusCreditAmt in table CusOrder and fields
CusOrderID and CreditAmt in table CusCredits. I would
like to update the value in the CusCreditAmt field in
CusOrder to equal the CreditAmt field in CusCredits where
CusOrderID is the same in both tables.
I tried doing this in a stored procedure based on a View
with an inner join between the 2 tables as follows:
Set CusCreditAmt = CreditAmt
I received an error that the subquery returned more than
one value. Is there anyway to do something like this and
make it work?