Learn how to write SQL update statement from SQL Select statement

Learn how to join multiple tables in SQL and then update one table from the joined tables

[@anthonynorman1212]

Thank You for the video
but
i am struggling a bit...
I have a list of Fuel Transactions which occured on various dates, i need attain the previous fuel transaction Date for the same vehicle_Id from the table and place it on the same row as the new transaction.
I thought about using update to reorder my table then applying an index; (pre_index = index - 1).
Is there any other way of sorting this out other than the method which i mentioned?

[@andelephantscanfly]

does this work for oracle

[@MAS777]

Hi Simon, apologies, I am not really sure. I did not try it before. But my guess is that it will use a different syntax