I have a web site that tracks helicopters. I capture the "from_location" "to_location", "off_time"and "on_time". It's know problem to calculate the flight time. I need a sql that will grab the next row "on_time" and subtract it from the current row "off_time", this will give me the helicopter standby time. Can anyone help?
Paul
Paul