Working with multiple rows

sf129

Registered User.
Local time
Today, 23:11
Joined
Mar 6, 2003
Messages
11
These are 6 different rows on a table. I need to combine dates that are consecutive.
start end
06/02/1999 06/03/1999
06/09/1999 06/29/1999
06/09/2000 06/30/2000
07/01/2000 07/06/2000
08/21/2000 08/31/2000
09/01/2000 09/12/2000

I would like to 4 rows instead of 6 reading like this:
start end
06/02/1999 06/03/1999
06/09/1999 06/29/1999
06/09/2000 07/06/2000
08/21/2000 09/12/2000

Can anyone tell me how to do this?
 

Users who are viewing this thread

Back
Top Bottom