首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >多部分标识符"“无法绑定。sqlserver上的错误

多部分标识符"“无法绑定。sqlserver上的错误
EN

Stack Overflow用户
提问于 2014-06-20 11:48:52
回答 1查看 96关注 0票数 0

我在sql server上写了一个查询。这是查询。

代码语言:javascript
运行
复制
 INSERT INTO #TEMPR(    
                            nQtyR ,
                            cBENoR ,
                            dBEDateR ,
                            nReceiveValueR ,
                            cRemarksR ,
                            nJobOrderDtlIdR ,
                            nSKUIdR ,
                            cSKUCodeR ,
                            cSKUDescriptionR,
                            nJobOrderIdR ,
                            cJobOrderNoR ,
                            nLocationIdR ,
                            LocCodeR,
                            nWtR ,
                            nVolR ,
                            cStatusR,
                            nASNIDR,
                            cPalletIDR )

                SELECT  SUM(WMS_InventoryTag.nCount) AS nQtyR, 
                    ISNULL(WMS_OutTurnDtl.cBENo,'') as cBENoR, 
                    WMS_OutTurnDtl.dBEDate as dBEDateR, 
                    isnull(WMS_OutTurnDtl.nReceiveValue,0) as nReceiveValueR, 
                    '' AS cRemarks, 
                    WMS_JobOrderDtl.nJobOrderDtlId as nJobOrderDtlIdR, 
                    WMS_SKUMst.nSKUId as nSKUIdR, 
                    WMS_SKUMst.cSKUCode as cSKUCodeR, 
                    WMS_SKUMst.cSKUDescription as cSKUDescriptionR,
                    WMS_JobOrder.nJobOrderId as nJobOrderIdR, 
                    WMS_JobOrder.cJobOrderNo as cJobOrderNoR,
                    WMS_LoactionMst.nLocationId as nLocationIdR,
                    WMS_LoactionMst.nLocationCode AS LocCodeR,
                    WMS_JobOrderDtl.nWt as nWtR,
                    WMS_JobOrderDtl.nVol as nVolR,
                    WMS_JobOrder.cStatus as cStatusR,
                    WMS_JobOrderDtl.nASNID as nASNIDR,
                    WMS_OutTurnDtl.cPalletID as cPalletIDR 
    FROM WMS_InventoryTrans inner JOIN WMS_OutTurnDtl ON WMS_OutTurnDtl.nOutTurnDtlId = WMS_InventoryTrans.nOutTurnDtlId 
                            INNER JOIN WMS_JobOrderDtl ON WMS_InventoryTrans.nJobOrderDtlId = WMS_JobOrderDtl.nJobOrderDtlId 
                            INNER JOIN WMS_SKUMst ON WMS_JobOrderDtl.nSKUId = WMS_SKUMst.nSKUId 
                            INNER JOIN WMS_JobOrder ON WMS_JobOrderDtl.nJobOrderId = WMS_JobOrder.nJobOrderId
                            INNER JOIN WMS_WarehouseMst ON WMS_WarehouseMst.nWarehouseId=WMS_JobOrder.nWarehouseId
                            INNER JOIN WMS_InventoryTag ON WMS_InventoryTrans.nInvTransId=WMS_InventoryTag.nInvTransId
                            INNER JOIN WMS_LoactionMst ON WMS_InventoryTag.nLocationId=WMS_LoactionMst.nLocationId
    WHERE WMS_JobOrder.cStatus='A' AND WMS_InventoryTag.cStatus='A' 
    AND 1=case when isnull(@JOBID,'')='' then 1 else case when WMS_JobOrder.nJobOrderId=@JOBID then 1 else 0 end end 
    and 1=case when isnull(@CUSTID,'')='' then 1 else case when WMS_JobOrder.nCustomer=@CUSTID then 1 else 0 end  end
    and 1=case when isnull(@locID,'')='' then 1 else case when WMS_LoactionMst.nLocationId=@locID then 1 else 0 end  end
    and 1=case when isnull(@asnID,'')='' then 1 else case when WMS_JobOrderDtl.nASNID=@asnID then 1 else 0 end  end
        and WMS_JobOrder.nWarehouseId=@WAREHOUSEID
    GROUP BY  WMS_OutTurnDtl.cBENo, WMS_OutTurnDtl.dBEDate, isnull(WMS_OutTurnDtl.nReceiveValue,0), 
              WMS_JobOrderDtl.nJobOrderDtlId, WMS_SKUMst.nSKUId, WMS_SKUMst.cSKUCode, WMS_SKUMst.cSKUDescription,
              WMS_JobOrder.nJobOrderId, WMS_JobOrder.cJobOrderNo,WMS_LoactionMst.nLocationId,WMS_LoactionMst.nLocationCode,WMS_JobOrder.cStatus,
              WMS_JobOrderDtl.nWt,
              WMS_JobOrderDtl.nVol,WMS_JobOrderDtl.nASNID,WMS_OutTurnDtl.cPalletID
    ORDER BY WMS_JobOrder.nJobOrderId

但当我抛出此查询时,它将返回错误messege

多部分标识符"WMS_OutTurnDtl.cPalletID“无法绑定。

我知道该怎么做。

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2014-11-04 10:26:21

检查WMS_OutTurnDtl表。检查所有列是否正确

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/24326584

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档