Hi

I have a table with REG numbers and their dates .What I did was create a summary table of the main table which has all the details like this :


REG TIMESTAMP
--------- ---------
0 18-JUN-99
8537 10-SEP-99
69281 04-OCT-99
71222 05-OCT-99
73340 06-OCT-99
75139 07-OCT-99
76848 08-OCT-99
79014 09-OCT-99
80474 10-OCT-99


using select max(reg) trunc(timestamp) from table A
group by trunc(timestamp)
order by trunc(timestamp) ;



The table A has all REG numbers and dates along with it .

I need to write a program where the details of the REG number will be taken from table B . and run against table A to get the dates.Timestamp is the registration date of the user. so to ensure that between 0 and 8537 all users registered on 18-JUN-99.

Eg REG between 0 and 8536 should have 18-JUN-99 as timestamp if not then show those REG and timestamp and then for 8537 and 69281 to have 10-SEP-99 in table A .


Hope it is clear .

regards