一家航空公司把一年中飞行距离(idistancetravelled)超过10000里的客户信息转移到一张称为flyersclub 的表中,他们的详细情况被记录在表flyers ( )。
A.
insert into flyersclub from flyers where idistancetravelled>=10000
B.
insert flyersclub (idistancetravelled) values from flyers where idistancetravelled>=10000
C.
insert into flyersclub from flyers where (idistancetravelled)values>=10000
D.
select * into flyersclub from flyers where idistancetravelled >=10000