电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

为何 这段SQL查询一个AND 条件就会卡死?

来源:金蝶云社区作者:金蝶2024-09-162

为何 这段SQL查询一个AND 条件就会卡死?

SELECT DISTINCT t_BOSqlgxhb.FID,t_BOSqlgxhb.FClassTypeID ,t_BOSqlgxhbEntry.FEntryID,t_BOSqlgxhbEntry.FIndex,t_User.FName FROM t_BOSqlgxhb
INNER JOIN t_BOSqlgxhbEntry ON t_BOSqlgxhb.FID=t_BOSqlgxhbEntry.FID
LEFT JOIN t_Item_3013 ON t_BOSqlgxhb.FGX=t_Item_3013.FItemID AND t_Item_3013.FItemID>0
LEFT JOIN t_User ON t_BOSqlgxhb.FBiller=t_User.FUserID AND t_User.FUserID>0
LEFT JOIN t_User t_User2 ON t_BOSqlgxhb.FModifier=t_User2.FUserID AND t_User2.FUserID>0
LEFT JOIN t_ICItem t_ICItem1 ON t_BOSqlgxhbEntry.FBase9=t_ICItem1.FItemID AND t_ICItem1.FItemID>0
LEFT JOIN t_ICItem ON t_BOSqlgxhbEntry.FitemID=t_ICItem.FItemID AND t_ICItem.FItemID>0
LEFT JOIN t_Item t_ICItem_FBaseProperty1 ON t_ICItem.F_121=t_ICItem_FBaseProperty1.FItemID AND t_ICItem_FBaseProperty1.FItemID>0
LEFT JOIN t_Item t_ICItem_FBaseProperty2 ON t_ICItem.F_150=t_ICItem_FBaseProperty2.FItemID AND t_ICItem_FBaseProperty2.FItemID>0
LEFT JOIN t_Item t_ICItem_FBaseProperty10 ON t_ICItem.F_141=t_ICItem_FBaseProperty10.FItemID AND t_ICItem_FBaseProperty10.FItemID>0
LEFT JOIN t_Item t_ICItem_FBaseProperty11 ON t_ICItem.F_131=t_ICItem_FBaseProperty11.FItemID AND t_ICItem_FBaseProperty11.FItemID>0
LEFT JOIN t_Measureunit ON t_BOSqlgxhbEntry.Funit=t_Measureunit.FItemID AND t_Measureunit.F

为何 这段SQL查询一个AND 条件就会卡死?

SELECT DISTINCT t_BOSqlgxhb.FID,t_BOSqlgxhb.FClassTypeID ,t_BOSqlgxhbEntry.FEntryID,t_BOSqlgxhbEntry.FIndex,t_User.FName ...
点击下载文档文档为doc格式

声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。

已经是第一篇
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信