- SQL code
SELECT acSiteGroup_AcquisitionInfo.fldGuid, acSiteGroup_AcquisitionInfo.fldName, acSiteGroup_AcquisitionContent.fldContentFROM acSiteGroup_AcquisitionInfo INNER JOIN acSiteGroup_AcquisitionContent ON acSiteGroup_AcquisitionContent.fldGuid = acSiteGroup_AcquisitionInfo.fldGuid WHERE (acSiteGroup_AcquisitionInfo.fldGuid NOT IN (SELECT fldInfoGuid FROM acSiteGroup_AcquisitionContentPost WHERE (fldPostGuid = @fldPostGuid))) limit 1, 10
我想查 acSiteGroup_AcquisitionInfo.fldGuid 不在 acSiteGroup_AcquisitionContentPost 表中的数据
当取消 limit 1, 10 条件时,能正确查处所有数据
但是加上运行之后就报错 错误:
Insufficient parameters supplied to the command
------解决方案--------------------------------------------------------