Update Statement only updates first joined record in list

[GJP55]

Can anybody explain why when running an update query, only one record is updated where there is a match in the join and not updated by all of the matches ?

I have a table that is being updated by the value of another table where they match account numbers.
The join is on account numbers and the table that has the values has multiple records with the same account number but only the first records value is updated ???

Code:

Update tblHist
Set Balance = Balance + A.Amount
From tblHist H
Inner join Adjustments A
On H.Accountnumber = A.Accountnumber

This will only update the accountnumber record in the history table with the first record that contains the same account number from the adjustments table (there are several matching account numbers)

Thanks


Group by h.accountnumber, t.accountnumber, amount

 

[philhege]

I take it the group by statement is extraneous to your update statement.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.

 

[GJP55]

Yes, that should not have been there.Please ignor it. Thanks