表或函数 'dbo.ComputationUnit' 和 'dbo.ComputationUnit' 具有相同的表现名称。请用相关名称区分它们。

xing0120 2012-01-16 07:48:31
SELECT rdrecords.AutoID, rdrecords.ID, rdrecords.cInvCode, dbo.Inventory.cInvAddCode,
dbo.Inventory.cInvName, dbo.Inventory.cInvStd, dbo.Inventory.cInvCCode,
dbo.ComputationUnit.cComUnitName AS cinvm_unit,
computationunit2.cComUnitName AS cinva_unit, dbo.Inventory.cReplaceItem,
rdrecords.cPosition, dbo.Inventory.cInvDefine1, dbo.Inventory.cInvDefine2,
dbo.Inventory.cInvDefine3, dbo.Inventory.cInvDefine4, dbo.Inventory.cInvDefine5,
dbo.Inventory.cInvDefine6, dbo.Inventory.cInvDefine7, dbo.Inventory.cInvDefine8,
dbo.Inventory.cInvDefine9, dbo.Inventory.cInvDefine10, dbo.Inventory.cInvDefine11,
dbo.Inventory.cInvDefine12, dbo.Inventory.cInvDefine13, dbo.Inventory.cInvDefine14,
dbo.Inventory.cInvDefine15, dbo.Inventory.cInvDefine16, dbo.Inventory.iId,
rdrecords.cFree1, rdrecords.cFree2, rdrecords.cFree3, rdrecords.cFree4,
rdrecords.cFree5, rdrecords.cFree6, rdrecords.cFree7, rdrecords.cFree8,
rdrecords.cFree9, rdrecords.cFree10, rdrecords.cBatch, rdrecords.iinvexchrate,
rdrecords.iNum, rdrecords.iQuantity, rdrecords.iUnitCost, rdrecords.iPrice,
rdrecords.cBarCode, rdrecords.iPUnitCost, rdrecords.iPPrice, rdrecords.dVDate,
rdrecords.cObjCode, rdrecords.iSOutQuantity, rdrecords.iSOutNum,
rdrecords.iNQuantity, rdrecords.iNNum, rdrecords.cAssUnit, rdrecords.dMadeDate,
rdrecords.iFQuantity, rdrecords.iFNum, rdrecords.cVouchCode, rdrecords.cDefine22,
rdrecords.cDefine23, rdrecords.cDefine24, rdrecords.cDefine25, rdrecords.cDefine26,
rdrecords.cDefine27, rdrecords.cDefine28, rdrecords.cDefine29, rdrecords.cDefine30,
rdrecords.cDefine31, rdrecords.cDefine32, rdrecords.cDefine33, rdrecords.cDefine34,
rdrecords.cDefine35, rdrecords.cDefine36, rdrecords.cDefine37, rdrecords.iMPoIds,
rdrecords.iCheckIds, rdrecords.cItemCode, rdrecords.cItem_class, rdrecords.cName,
rdrecords.cItemCName, rdrecords.cBVencode, dbo.Vendor.cVenName,
rdrecords.iMassDate, rdrecords.cInVouchCode, rdrecords.iMaterialFee,
rdrecords.iOMoMID, rdrecords.iOMoDID, rdrecords.comcode,
(CASE rdrecords.cmassunit WHEN 0 THEN N'' WHEN 1 THEN N'年' WHEN 2 THEN N'月'
WHEN 3 THEN N'日' ELSE NULL END) AS cmassunit, dbo.[Position].cPosName,
rdrecords.iSQuantity, rdrecords.iSMaterialFee, rdrecords.dMSDate,
rdrecords.cmocode, rdrecords.imoseq, rdrecords.cMoLotCode, rdrecords.iopseq,
rdrecords.copdesc, rdrecords.cmworkcentercode,
dbo.sfc_workcenter.Description AS cmworkcenter, rdrecords.invcode,
Inventory2.cInvName AS invname, Inventory2.cInvStd AS invstd,
CONVERT(nvarchar(50), N'') AS corufts, rdrecords.isodid, ISNULL(rdrecords.isotype, 0)
AS isotype, rdrecords.csocode, rdrecords.isoseq,
(CASE WHEN isnull(rdrecords.isotype, 0)
= 4 THEN isnull(AA_RequirementClass.cRClassName, '') ELSE '' END)
AS cdemandmemo, rdrecords.iordertype, rdrecords.iorderdid, rdrecords.iordercode,
rdrecords.iorderseq, rdrecords.cbaccounter, rdrecords.bCosting,
rdrecords.dbKeepDate, rdrecords.cvmivencode, v1.cVenAbbName AS cvmivenname,
ISNULL(rdrecords.bVMIUsed, 0) AS bvmiused, rdrecords.iVMISettleQuantity,
rdrecords.iVMISettleNum, rdrecords.iMaIDs, rdrecords.iInvSNCount,
(CASE WHEN inventory.bSerial = 0 THEN NULL ELSE abs(isnull(rdrecords.iquantity,
0)) - isnull(rdrecords.iinvsncount, 0) END) AS iuninvsncount,
rdrecords.cwhpersoncode, rdrecords.cwhpersonname, rdrecords.cRejectCode,
rdrecords.iExpiratDateCalcu, rdrecords.cExpirationdate, rdrecords.dExpirationdate,
rdrecords.cciqbookcode, rdrecords.iBondedSumQty, rdrecords.productinids,
rdrecords.cBatchProperty1, rdrecords.cBatchProperty2, rdrecords.cBatchProperty3,
rdrecords.cBatchProperty4, rdrecords.cBatchProperty5, rdrecords.cBatchProperty6,
rdrecords.cBatchProperty7, rdrecords.cBatchProperty8, rdrecords.cBatchProperty9,
rdrecords.cBatchProperty10, rdrecords.iRSRowNO, rdrecords.cbMemo,
CONVERT(nvarchar(60), '') AS cbinvsn, rdrecords.applydid, rdrecords.applycode,
rdrecords.irowno, rdrecords.strowguid, v1.iId AS vmiveniid, rdrecords.cservicecode,
dbo.Vendor.iId AS bveniid, rdrecords.cinvouchtype, rdrecords.coutvouchid,
rdrecords.coutvouchtype, rdrecords.iSRedOutQuantity, rdrecords.iSRedOutNum,
rdrecords.iTrIds, rdrecords.ipesodid, rdrecords.ipesotype, rdrecords.cpesocode,
rdrecords.ipesoseq, rdrecords.bsupersede, rdrecords.isupersedeqty,
rdrecords.isupersedempoids, rdrecords.imoallocatesubid
FROM dbo.rdrecords11 rdrecords LEFT OUTER JOIN
dbo.Inventory WITH (nolock) ON
rdrecords.cInvCode = dbo.Inventory.cInvCode LEFT OUTER JOIN
dbo.ComputationUnit WITH (nolock) ON
dbo.Inventory.cComUnitCode = dbo.ComputationUnit.cComunitCode LEFT OUTER JOIN
dbo.ComputationUnit WITH (nolock) computationunit2 ON
rdrecords.cAssUnit = computationunit2.cComunitCode LEFT OUTER JOIN
dbo.Vendor WITH (nolock) ON
rdrecords.cBVencode = dbo.Vendor.cVenCode LEFT OUTER JOIN
dbo.Vendor WITH (nolock) v1 ON
rdrecords.cvmivencode = v1.cVenCode LEFT OUTER JOIN
dbo.[Position] WITH (nolock) ON
rdrecords.cPosition = dbo.[Position].cPosCode LEFT OUTER JOIN
dbo.Inventory WITH (nolock) Inventory2 ON
rdrecords.invcode = Inventory2.cInvCode LEFT OUTER JOIN
dbo.sfc_workcenter WITH (nolock) ON
dbo.sfc_workcenter.WcCode = rdrecords.cmworkcentercode LEFT OUTER JOIN
dbo.AA_RequirementClass ON
dbo.AA_RequirementClass.cRClassCode = rdrecords.isodid AND
ISNULL(rdrecords.isotype, 0) = 4
...全文
628 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
xing0120 2012-02-14
  • 打赏
  • 举报
 回复
SELECT rdrecords.AutoID, rdrecords.ID, rdrecords.cInvCode, Inventory1.cInvAddCode,
Inventory1.cInvName, Inventory1.cInvStd, Inventory1.cInvCCode,
ComputationUnit1.cComUnitName AS cinvm_unit,
computationunit2.cComUnitName AS cinva_unit, Inventory1.cReplaceItem,
rdrecords.cPosition, Inventory1.cInvDefine1, Inventory1.cInvDefine2,
Inventory1.cInvDefine3, Inventory1.cInvDefine4, Inventory1.cInvDefine5,
Inventory1.cInvDefine6, Inventory1.cInvDefine7, Inventory1.cInvDefine8,
Inventory1.cInvDefine9, Inventory1.cInvDefine10, Inventory1.cInvDefine11,
Inventory1.cInvDefine12, Inventory1.cInvDefine13, Inventory1.cInvDefine14,
Inventory1.cInvDefine15, Inventory1.cInvDefine16, Inventory1.iId, rdrecords.cFree1,
rdrecords.cFree2, rdrecords.cFree3, rdrecords.cFree4, rdrecords.cFree5,
rdrecords.cFree6, rdrecords.cFree7, rdrecords.cFree8, rdrecords.cFree9,
rdrecords.cFree10, rdrecords.cBatch, rdrecords.iinvexchrate, rdrecords.iNum,
rdrecords.iQuantity, rdrecords.iUnitCost, rdrecords.iPrice, rdrecords.cBarCode,
rdrecords.iPUnitCost, rdrecords.iPPrice, rdrecords.dVDate, rdrecords.cObjCode,
rdrecords.iSOutQuantity, rdrecords.iSOutNum, rdrecords.iNQuantity, rdrecords.iNNum,
rdrecords.cAssUnit, rdrecords.dMadeDate, rdrecords.iFQuantity, rdrecords.iFNum,
rdrecords.cVouchCode, rdrecords.cDefine22, rdrecords.cDefine23,
rdrecords.cDefine24, rdrecords.cDefine25, rdrecords.cDefine26, rdrecords.cDefine27,
rdrecords.cDefine28, rdrecords.cDefine29, rdrecords.cDefine30, rdrecords.cDefine31,
rdrecords.cDefine32, rdrecords.cDefine33, rdrecords.cDefine34, rdrecords.cDefine35,
rdrecords.cDefine36, rdrecords.cDefine37, rdrecords.iMPoIds, rdrecords.iCheckIds,
rdrecords.cItemCode, rdrecords.cItem_class, rdrecords.cName,
rdrecords.cItemCName, rdrecords.cBVencode, v1.cVenName, rdrecords.iMassDate,
rdrecords.cInVouchCode, rdrecords.iMaterialFee, rdrecords.iOMoMID,
rdrecords.iOMoDID, rdrecords.comcode,
(CASE rdrecords.cmassunit WHEN 0 THEN N'' WHEN 1 THEN N'年' WHEN 2 THEN N'月'
WHEN 3 THEN N'日' ELSE NULL END) AS cmassunit, dbo.[Position].cPosName,
rdrecords.iSQuantity, rdrecords.iSMaterialFee, rdrecords.dMSDate,
rdrecords.cmocode, rdrecords.imoseq, rdrecords.cMoLotCode, rdrecords.iopseq,
rdrecords.copdesc, rdrecords.cmworkcentercode,
dbo.sfc_workcenter.Description AS cmworkcenter, rdrecords.invcode,
Inventory2.cInvName AS invname, Inventory2.cInvStd AS invstd,
CONVERT(nvarchar(50), N'') AS corufts, rdrecords.isodid, ISNULL(rdrecords.isotype, 0)
AS isotype, rdrecords.csocode, rdrecords.isoseq,
(CASE WHEN isnull(rdrecords.isotype, 0)
= 4 THEN isnull(AA_RequirementClass.cRClassName, '') ELSE '' END)
AS cdemandmemo, rdrecords.iordertype, rdrecords.iorderdid, rdrecords.iordercode,
rdrecords.iorderseq, rdrecords.cbaccounter, rdrecords.bCosting,
rdrecords.dbKeepDate, rdrecords.cvmivencode, v2.cVenAbbName AS cvmivenname,
ISNULL(rdrecords.bVMIUsed, 0) AS bvmiused, rdrecords.iVMISettleQuantity,
rdrecords.iVMISettleNum, rdrecords.iMaIDs, rdrecords.iInvSNCount,
(CASE WHEN inventory.bSerial = 0 THEN NULL ELSE abs(isnull(rdrecords.iquantity,
0)) - isnull(rdrecords.iinvsncount, 0) END) AS iuninvsncount,
rdrecords.cwhpersoncode, rdrecords.cwhpersonname, rdrecords.cRejectCode,
rdrecords.iExpiratDateCalcu, rdrecords.cExpirationdate, rdrecords.dExpirationdate,
rdrecords.cciqbookcode, rdrecords.iBondedSumQty, rdrecords.productinids,
rdrecords.cBatchProperty1, rdrecords.cBatchProperty2, rdrecords.cBatchProperty3,
rdrecords.cBatchProperty4, rdrecords.cBatchProperty5, rdrecords.cBatchProperty6,
rdrecords.cBatchProperty7, rdrecords.cBatchProperty8, rdrecords.cBatchProperty9,
rdrecords.cBatchProperty10, rdrecords.iRSRowNO, rdrecords.cbMemo,
CONVERT(nvarchar(60), '') AS cbinvsn, rdrecords.applydid, rdrecords.applycode,
rdrecords.irowno, rdrecords.strowguid, v2.iId AS vmiveniid, rdrecords.cservicecode,
v1.iId AS bveniid, rdrecords.cinvouchtype, rdrecords.coutvouchid,
rdrecords.coutvouchtype, rdrecords.iSRedOutQuantity, rdrecords.iSRedOutNum,
rdrecords.iTrIds, rdrecords.ipesodid, rdrecords.ipesotype, rdrecords.cpesocode,
rdrecords.ipesoseq, rdrecords.bsupersede, rdrecords.isupersedeqty,
rdrecords.isupersedempoids, rdrecords.imoallocatesubid
FROM dbo.rdrecords11 rdrecords LEFT OUTER JOIN
dbo.Inventory WITH (nolock) Inventory1 ON
rdrecords.cInvCode = Inventory1.cInvCode LEFT OUTER JOIN
dbo.ComputationUnit WITH (nolock) ComputationUnit1 ON
Inventory1.cComUnitCode = ComputationUnit1.cComunitCode LEFT OUTER JOIN
dbo.ComputationUnit WITH (nolock) computationunit2 ON
rdrecords.cAssUnit = computationunit2.cComunitCode LEFT OUTER JOIN
dbo.Vendor WITH (nolock) v1 ON
rdrecords.cBVencode = v1.cVenCode LEFT OUTER JOIN
dbo.Vendor WITH (nolock) v2 ON
rdrecords.cvmivencode = v2.cVenCode LEFT OUTER JOIN
dbo.[Position] WITH (nolock) ON
rdrecords.cPosition = dbo.[Position].cPosCode LEFT OUTER JOIN
dbo.Inventory WITH (nolock) Inventory2 ON
rdrecords.invcode = Inventory2.cInvCode LEFT OUTER JOIN
dbo.sfc_workcenter WITH (nolock) ON
dbo.sfc_workcenter.WcCode = rdrecords.cmworkcentercode LEFT OUTER JOIN
dbo.AA_RequirementClass ON
dbo.AA_RequirementClass.cRClassCode = rdrecords.isodid AND
ISNULL(rdrecords.isotype, 0) = 4
xing0120 2012-01-18
  • 打赏
  • 举报
 回复
兄弟，我改过来了，在查询分析器里面没有问题了。但是在视图里面就说出错。
gogodiy 2012-01-17
  • 打赏
  • 举报
 回复 


LEFT OUTER JOIN

  dbo.ComputationUnit WITH (nolock) ON  

  dbo.Inventory.cComUnitCode = dbo.ComputationUnit.cComunitCode LEFT OUTER JOIN

  dbo.ComputationUnit WITH (nolock) computationunit2 ON  

  rdrecords.cAssUnit = computationunit2.cComunitCode

这里出现了2次dbo.ComputationUnit，第2次出现的时候你的别名位置不对，改成


LEFT OUTER JOIN

  dbo.ComputationUnit as A WITH (nolock) ON  

  dbo.Inventory.cComUnitCode = A.cComunitCode LEFT OUTER JOIN

  dbo.ComputationUnit as computationunit2 WITH (nolock) ON  

  rdrecords.cAssUnit = computationunit2.cComunitCode

两张表都要用别名，另外别忘记前面SELECT后面的字段也要进行同步别名的修改。
xing0120 2012-01-17
  • 打赏
  • 举报
 回复
自表连接,可以考虑这样使用

select m.* , n.* from tb m , tb n where m... = n...



哥，可以优化一下给我不？ 我急用！已经加班两天两夜啦！
xing0120 2012-01-17
  • 打赏
  • 举报
 回复
谢谢，兄弟，你太给力了。
koumingjie 2012-01-16
  • 打赏
  • 举报
 回复
好长好长的sql啊
dawugui 2012-01-16
  • 打赏
  • 举报
 回复
自表连接,可以考虑这样使用

select m.* , n.* from tb m , tb n where m... = n...
用友U8调拨单序列号查询SQL语句（含行转置）
本文提供了一条SQL查询语句，用于在用友U8系统中查询调拨单的详细信息，包括调拨单号、调出仓库、调入仓库、存货编码、序列号管理状态等关键数据。查询结果还包括是否为序列号管理、批号和序列号等细节，适用于需要跟踪存货序列号的业务场景。
＜数据集＞yolo安全手套佩戴识别＜目标检测＞
YOLO与VOC格式的安全手套佩戴识别数据集，适用于YOLO系列、Faster Rcnn、SSD等模型训练，类别：Not Glove Wearing、Glove Wearing，图片数量4684。文件中包含图片、txt标签、指定类别信息的yaml文件、xml标签，已将图片和txt标签划分为训练集、验证集和测试集，可直接用于YOLOv5、YOLOv6、YOLOv7、YOLOv8、YOLOv9、YOLOv10、YOLOv11、YOLOv12、YOLOv13、YOLOv26等YOLO系列算法的训练。 数据集介绍链接：https://blog.csdn.net/qq_53332949/article/details/161738649?spm=1011.2415.3001.5331
基于下垂系数功率分配的双机并联VSG微电网黑启动控制仿真研究（Simulink仿真实现）
内容概要：本文围绕基于下垂系数功率分配的双机并联虚拟同步发电机（VSG）微电网黑启动控制开展研究，重点利用Simulink仿真平台构建系统模型，实现微电网在无外部电网支撑条件下的自主启动与稳定运行。研究通过引入VSG技术模拟同步发电机的惯性和阻尼特性，结合下垂控制策略实现双机并联系统在黑启动过程中的有功与无功功率协调分配，有效抑制电压频率波动和功率振荡问题。文中详细阐述了控制系统的架构设计、核心控制环路的实现方式、关键参数的整定方法，并通过仿真结果验证了所提出控制策略在动态响应、负载突变及系统恢复等方面的优越性能，为提升微电网的自主恢复能力与供电可靠性提供了有效的技术路径。; 适合人群：具备电力系统、电力电子与自动控制等相关专业知识背景，熟悉Simulink/MATLAB仿真环境，从事微电网、分布式能源系统、VSG控制等领域研究的科研人员、高校教师及硕士、博士研究生。; 使用场景及目标：①深入理解虚拟同步发电机（VSG）的工作原理及其在黑启动中的应用价值；②掌握基于下垂控制的双机并联系统功率均分与稳定控制技术；③构建完整的微电网黑启动仿真模型，服务于科研论文撰写、课题申报、实验教学或工程预研。; 阅读建议：此资源以仿真为核心手段，建议读者在学习过程中结合理论分析，动手搭建Simulink模型，逐步调试控制器参数，深入探究下垂系数、虚拟惯量等关键参数对系统动态性能的影响，并可进一步拓展至多机并联、含储能单元或复杂负载工况的场景进行深化研究。
World's First Full-Chinese Ray-Ban Meta AI Assistant - 全球首个全中文 R.zip
AI 解题助手，考试助手，在「面试」或「在线考试」时，借助AI实时提供解题思路和答案。
SpringAI项目学习.zip
基于 SpringAI 的 Agent 开发项目：一个面向“组织知识库 + AI 助手”的 RAG Agent实战项目，把权限隔离、文档入库、混合检索、证据约束、Agent 工具调用和 Docker 部署串成了一条完整工程链路。如果你正在找一个能写进简历、能讲清架构、能覆盖 S…
应用实例

27,581

社区成员

68,548

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server 应用实例
社区管理员
  • 应用实例社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章