Re: INSERT INTO Child Tables

Hi:
you can do the next:

insert into child_aux
select *
from child
where station_key

            in (select station_key
                 from  parent
                 WHERE date_time >=to_date(to_char(sysdate -
10),'yyyymmddhh24'),
                                                     yyyymmddhh24');

I hope it's useful to you
Regards,
Isa Received on Tue Jan 24 2006 - 09:41:14 CST