查询归档日志

select t.team_duty_id,
       t.team_master_id,
       t.team_master,
       s.id,
       s.name_id,
       s.names
  from prod_runlog_team_duty t,
       (select team_duty_id id, team_master_id name_id, team_master names
          from prod_runlog_team_duty as of timestamp to_date('2009-04-20 10:50', 'yyyy-mm-dd hh24:mi')) s
 where t.team_duty_id = s.id