• Please provide us with your code and sample data from both tables.

    Just guessing from what you write, you left join table2 to table1 with the _Movement_ ID.

    You will first need to derive the next _Movement_ ID for each row in table2 and then alter your join condition to between _Movement_ ID and next _Movement_ ID -1.