Hi,
Say I have this table schema.
ID AccNo Amount
Say I have this data
ID AccNo Amount
1 1020 100.00
2 2040 50.00
How do I write a TSQL update query to update AccNo 1020 amount column with the amount from 2040??
Malcolm