SQL: Replace (Access)

0
|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

    
asked by Enrique Salazar 20.07.2018 в 18:07
source

0 answers