求一个oracle的查询语句
有两张表，
ads_box：字段：boxid,              ads_thing:字段：boxid,
                                name,                                             num,
                                 .......                                                time,
                                
box表的boxid是唯一的，而thing表以boxid和time为主键，boxid不唯一。
ads_box： boxid               name                     ads_thing:       boxid                 num                   time
                      1                 test1                                                           1                 1.10            2013-01-01 00:00:00
                      2                 test2                                                           1                  2.10           2013-01-01 00:30:00
                           .......                                                  &nbs