My SQL statment would look like:
SELECT table1.value1, table1.value2, table2.value1
FROM table1, table2
WHERE table1.[increment number] > table2.[Value2] (here is the part I can't figure out) AND...

Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number.

Example...

My rows are not numbered. Any other suggestions?

Thanks!

Is there a keyword in SQL that would allow you to select a value from a field in the previous row? I am looking for something that would give me the speed field value for the row before:
SELECT...

Thanks for your help. The above statement did work. But, brought on a follow up question, how can I also select the other fields in the table with this statement?

What I want is certain fields...

Hopefully this will be an easy one for someone.

I am trying to write a SELECT statement that pulls the row with the least time for each Special Number.

Example data would be:

Time ...