I would like to have output like this:

LEGID NEXTLEGID REQUESTID previous_legid, Previous_intime, TURN_TIME*

111 ...

Jeff,

Thank you for your input. But I think I didn't make it clear.

For Requestid 0021, there are two legids associated with it(112, 324). For each leg, I should...

Jeff Moden (5/17/2009)

---

Frank He (5/17/2009)

---

In aircraft industry, the flight from one place to its destination called leg, but some requests have mulitple stops (legs). I need to caculate the turn...