Q:SQL:How to update pagenumbers

Hello *.*
i've got a high problem in my little opinion. there is a table like this :

company	number	page	timestamp(MM.DD.YY)
11	123	1	07.09.98
11	123	2	07.09.98
11	123	1	09.09.98
11	123	2	09.09.98

now, i must renumber the page of the youngest records. the table must look like this :

company	number	page	timestamp(MM.DD.YY)
11	123	1	07.09.98
11	123	2	07.09.98
11	123	3	09.09.98
11	123	4	09.09.98

Is there somebody who can help me ?
--

bye
Ralf Bender
(mailto:Ralf.Bender_at_wolnet.de) Received on Sun Oct 11 1998 - 14:43:25 CDT