读书人

Sqlite 语法出错解决方法

发布时间: 2012-02-10 21:27:41 作者: rapoo

Sqlite 语法出错

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

[解决办法]

读书人网 >其他数据库

热点推荐