SQL表之间导入问题

[gagaxiaoyuer]

两个数据库 1。 JCxt 2。 Powerzs JC下面一个表 jf_jicjk_bak， PZ下面有两个表 POWER_METER 和 POWER_READING
现在我想把
insert into dbo.jf_jicjk_bak(jubh,chaobsj,jilfx,yuef,biaomyg,biaomwg,yougfdd,youggdd,wugfdd,wugpdd,wuggdd,yicdm,chaobbh)
select FMTR_ID,FREAD_DATE,FREAD_DAY_START FROM POWER_METER,POWER_READING
WHERE DBO.power_meter.FMTR_ID=DBO.JF_JICJK_BAK.JUBH
and jf_jicjk_bak.chaobsj=power_reading.FREAD_DATE
and jf_jicjk_bak.biaomyg=power_reading.FREAD_DAY_START

总的意思就是跨数据库导入 把POWER_METER,POWER_READING着两个表里面的一些资料 导入到JCxt这个数据库jf_jicjk_bak这个表里面 大家帮忙看看

[ojuju10]

--都加上库名和所有者
insert into JCxt.dbo.jf_jicjk_bak(jubh,chaobsj,jilfx,yuef,biaomyg,biaomwg,yougfdd,youggdd,wugfdd,wugpdd,wuggdd,yicdm,chaobbh) 
select FMTR_ID,FREAD_DATE,FREAD_DAY_START FROM Powerzs.dbo.POWER_METER,Powerzs.dbo.POWER_READING 
WHERE DBO.power_meter.FMTR_ID=DBO.JF_JICJK_BAK.JUBH 
and jf_jicjk_bak.chaobsj=power_reading.FREAD_DATE 
and jf_jicjk_bak.biaomyg=power_reading.FREAD_DAY_START  

[-狙击手-]

oh

[liangCK]

[Quote=引用 1 楼 ojuju10 的回复:]
SQL code
--都加上库名和所有者
insert into JCxt.dbo.jf_jicjk_bak(jubh,chaobsj,jilfx,yuef,biaomyg,biaomwg,yougfdd,youggdd,wugfdd,wugpdd,wuggdd,yicdm,chaobbh)
select FMTR_ID,FREAD_DATE,FREAD_DAY_START FROM Powerzs.dbo.POWER_METER,Powerzs.dbo.POWER_READING
WHERE DBO.power_meter.FMTR_ID=DBO.JF_JICJK_BAK.JUBH
and jf_jicjk_bak.chaobsj=power_reading.FREAD_DATE
and jf_jicjk_bak.biaomyg=power_re…
[/Quote]
同意.

[gagaxiaoyuer]

The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns. 出现这个啥意思

[liangCK]

insert的列数跟select的列数要一致.

[gagaxiaoyuer]

那我不要的可以就打两是双引号不

[liangCK]

insert into tb1(f1,f2,f3)
 select f2,f2,f3
 from tb2

[liangCK]

--错误

insert into tb1(f1,f2,f3)
 select f1,f2
  from tb2

--错误
insert into tb1(f1,f2)
  select f1,f2,f3
  from tb2

--正确
insert into tb1(f1,f2,f3)
 select f2,f2,f3
 from tb2

[gagaxiaoyuer]

谢拉

[ojuju10]

ding