|ID|cuenta| |ID|cuenta|
|1 |"312" | |1|"0" |
|2 | "422"|---------> |2|"312" |
|3 | "55" | |3|"422" |
Hello, I am looking for a query that can replace a data from one record with another from the same column but from another record, in this case I want to replace it with the one above.
- I do not know how to reference data from another record.
- It does not matter if you have to add a first column to achieve "0".
- What kind of command
replace,update,delete for
can work or a query technique to achieve this. - Any suggestions help, mainly those that help me in how to refer to data from another record.
- I'm using SQL from Access .
- I attach the wished really