如何把查询结果插入到新的表里?

来源：百度知道 编辑：UC知道 时间：2024/06/05 14:18:59
select zjm,cpmc,sum(sl) 数量 from (
select zjm,cpmc,sl from table200811 group by zjm,cpmc, sl
union all select zjm,cpmc,sl from table200812 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200901 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200902 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200903 group by zjm,cpmc,sl ) dd group by zjm,cpmc

怎么样把查询的结果插入到新的table里?
测试了下,说是没有为第三列(属于newtabel)指定列?

  1. 将查询的结果作为插入新表的值，但是要和新表的属性一直，例如

  2. insert a(aa,bb) values(select aa,bb from t)

两种写法
一
select zjm,cpmc,sum(sl) 数量 into 新表名 from (
select zjm,cpmc,sl from table200811 group by zjm,cpmc, sl
union all select zjm,cpmc,sl from table200812 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200901 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200902 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200903 group by zjm,cpmc,sl ) dd group by zjm,cpmc

二
insert into 新表名 (zjm,cpmc,数量)
select zjm,cpmc,sum(sl) 数量 from (
select zjm,cpmc,sl from table200811 group by zjm,cpmc, sl
union all select zjm,cpmc,sl from table200812 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200901 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200902 group by zjm,cpmc,sl
union all select zjm,cpmc,sl from table200903 group by zjm,