Update table with information from another 1

[Freemo]

I wonder if anyone can help. I have 2 tables, table 1 and table 2. In table 1 i have the following columns:
TransactionId
Insurer
Net
Comms
In table 2 i have:
TransactionId
Fee
I have added a column named Fee to table 1 and would like to update it with the value from the Fee column in table 2 where the transactionid's match.

Can anyone help?

Many thanks

 

[bborissov]

UPDATE Table1 SET Fee = Table2.Fee
FROM Table1
INNER JOIN Table2 ON Table1.TransactionId = Table2.TransactionId

not tested

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[Freemo]

Thanks - works a treat