一家航空公司把一年中飞行距离超过10000里的客户全部信息从名为flyers的表中转移到一张称为flyersclub的表中,该操作的语句为()
A.
insert into flyersclub from flyers where idistancetravelled>=10000
B.
insert flyersclub where idistancetravelled>=10000
C.
insert into flyersclub from flyers where (idistancetravelled)values>=10000
D.
insert flyersclub (idstancetravelled) values from flyers whe