SQL HELO PLEASE !!!!!!!!!!

From: Dan White <dwhite_at_icimail.com>
Date: 4 Dec 2001 11:40:14 -0800
Message-ID: <9uj8qu029nj@drn.newsguy.com>

Hello all,

I have the following problem
I have column the was incorectly populated(over time) what I need to do is updqte the expiration_date column to the correct value here is my data(i have approxametly 8,000,000 rows to do this on )LN is not an actual value in the table but only for illistration purposes what I need to do is update the expiration_date from LN1 to the create_date of Ln 2
and the expire date of ln2 with the create_date of ln3 ANY HELP IS GREATLY APPRICATED AND THANKS IN ADVANCE what I have
LN code create_date expire_date status
------- -------------------- --------------------- ------------

1  1002	07-SEP-2001 14:57:15	22-OCT-2001 07:42:26	N
2  1002	13-SEP-2001 01:01:35	22-OCT-2001 07:42:26	N
3  1002	22-OCT-2001 07:42:26		                Y

What I want to see
LN code    create_date             expire_date          status


------- --------------------    ---------------------   ------------

1  1002	07-SEP-2001 14:57:15	13-SEP-2001 01:01:35	N
2  1002	13-SEP-2001 01:01:35	22-OCT-2001 07:42:26	N
3  1002	22-OCT-2001 07:42:26		                Y

Dan White
programmer/analyst Received on Tue Dec 04 2001 - 13:40:14 CST