最爱
获得徽章 0
- 报错：列名或所提供值的数目与表定义不匹配。begin tran
insert into MT_InspectItem
select
serialno,
FeeItemCode,
[entry name],
Scope,
SpecimenId,
SpecimenName,
OrgId,
OptEmployeeId,
OptEmployeeName,
OptTime,
SpellCode,
StrokeCode,
Memo,
Status,
IsDelete,
InspectItemUnitId,
InspectItemUnitName
from ws where [entry name] not in(select d.[entry name] from (select a.* from ws a, MT_InspectItem b where b.InspectItemName like CONCAT('%',a.[entry name],'%')) d group by d.[entry name] having COUNT([entry name])>1
) and [amount of money] is not null
rollback tran
执行中间查询部分是没问题的，但是全部执行就说列名或所提供值的数目与表定义不匹配。麻烦大佬们帮忙看看问题出在哪，感谢感谢![[流泪]](//lf-web-assets.juejin.cn/obj/juejin-web/xitu_juejin_web/img/jj_emoji_6.dde0d83.png)
展开3点赞
![[流泪]](http://lf-web-assets.juejin.cn/obj/juejin-web/xitu_juejin_web/img/jj_emoji_6.dde0d83.png)