Unanswered: How to update a field in row2 with a value from row1 and so on...
f1 integer PK
1, 0, 3
2, 0, 4
3, 0, 5
what i would like to know how to do is how do i get the f3 value from row1 into the f2 value of row2 and then copy the f3 value of row2 into f2 value of row3?