新手求助：sql语句，从多个表中取出最新时间的记录，组成一个新表

Question

Answer 1

mysql的实现：
insert into zongbiao(id, name ,vd,co2,wendu,time) select t1.id,t1.name,t1.vd,t2.co2,t2.wendu,t2.time from biao1 t1 join biao2 t2 on(t1.id=t2.id)
order by t2.time desc limit 1;