excel - '没有为一个或多个必需参数指定值' IN 运算符
问题描述
使用 Excel 2007 VBA
Excel 工作表中的表格
使用 ADODB 连接和记录集
这有效:
select *
from [tblBFLC$]
where [Body ID] IN (select DISTINCT [Body ID]
from [tblBody$]
where [Luminaire Type] = 'Interior') and [LED Type] = 'COB'
这不起作用:
select *
from [tblBFLC$]
where [Family ID] IN (select DISTINCT [Family ID]
from [tblFamily$]
where [Family] = 'ACLAP') and [LED Type] = 'COB'
我检查了正确的字段名称。
语法错误:
没有为一个或多个必需参数指定值
解决方案
推荐阅读
- javascript - 在递归函数中将数据推送到父级
- ssh - SSH works until 'sudo ssh' is used, then URL gets connection refused
- .net-core - How to host React App and Dot Net core webAPI with SignalR in AWS and Docker environment
- sql-server - Datagridview 使用 SQL Server 显示没有数据 vb.net
- reactjs - 这是什么模式在 React 中使用箭头函数?
- go - Go libstd.so with errors on Alpine
- jasper-reports - How to get sum of the XML repeated element values from a list in report?
- spring-boot - Jhipster 无法在登录前使用匿名用户
- swift - Backslash in string from standard input, no way to stripe it
- typoscript - TYPO3 Dynamic Localized Label in TypoScript