为什么执行INSERT INTO SELECT from where语句时会显示“操作符/操作数不匹配”。
原语句如下:INSERT INTO SYSH(区县代码,机构代码,库名,编号,错误信息) SELECT distinct "",sh1.xxdm,"基础112,522",sh1.k07,"体育运动场(馆)面积已达标,而无面积"+"["+sh1.k07+","+sh2.f+"]" FROM sh1,sh2 WHERE sh1.k07='是' AND sh1.xxdm=sh2.xxdm AND sh2.f<=12
其中:sh1,sh2均为表名,k07为文本型字段,f为数值型字段(数值型,20,5)
在线等!!!急用!