将查询出来的结果插入到一张新表里怎么做?
这是我的查询语句
select Scode,Insteadid,Standardrelated,Utradetype from Standarddata where Utradetype like '%食品类% ' or Utradetype like '%种植类% ' or Utradetype like '%畜牧类% ' or Utradetype like '%水产类% '
我要把这些查询结果插到一张新表里,怎么操作?
------解决方案--------------------如果表存在.
insert into temp
select Scode,Insteadid,Standardrelated,Utradetype from Standarddata where Utradetype like '%食品类% ' or Utradetype like '%种植类% ' or Utradetype like '%畜牧类% ' or Utradetype like '%水产类% '