一家航空公司把一年中飞行距离超过10000里的客户信息转移到一张称为flyersclub的表中,他们的详细情况被记录在表flyers,下列sQL语句描述正确的是——。
A.
insert flyersclub where idistancetravelled>=1 0000
B.
insert into flyersclub from flyers where idistancetravelled>=10000
C.
insert into flyersclub from flyers where(idistancetravelled)values>=10000
D.
insert flyersclub(idstancetravelled)values from flyers where idistancetravelled>=10000