将查询结果保存为新表解决方案

将查询结果保存为新表
create   table   as   xx  
(selectatmjyje.jgm,atmjyje.jgmc,atmjyje.jyje,atmjybs.jybs,atmjyje.jyje/atmjybs.jybs   as   mbjybs   from   atmjybs   inner   join   atmjyje
on   atmjyje.jgm=atmjybs.jgm   and   atmjyje.jgmc=atmjybs.jgmc)
麻烦看下这段错在哪里，谢谢拉

[解决办法]
select
atmjyje.jgm,atmjyje.jgmc,atmjyje.jyje,atmjybs.jybs,atmjyje.jyje/atmjybs.jybs as mbjybs
into xx
from atmjybs inner join atmjyje
on atmjyje.jgm=atmjybs.jgm and atmjyje.jgmc=atmjybs.jgmc