错误:无法绑定多部分标识符. [英] Error: The multi-part identifier could not be bound.

问题描述

with tempcte(cj_PaymentMode,cj_Chequeorddno,cj_Chequeordddate,cj_Bankname,cj_BankBranch,cj_Branchaddress)
as
(
select cj_PaymentMode,cj_Chequeorddno,cj_Chequeordddate,cj_Bankname,cj_BankBranch,cj_Branchaddress from cj_Invoicedetails where cj_TransactionID = 'AX01'
)
update @checkorder set cj_PaymentType =tempcte.cj_PaymentMode,cj_Chequeddno =tempcte.cj_Chequeorddno,cj_Chequedddate =tempcte.cj_Chequeordddate,cj_Bankname =tempcte.cj_Bankname,cj_Bankloc =tempcte.cj_BankBranch,cj_Branchaddr =tempcte.cj_Branchaddress where cj_TransactionID = 'AX01'

执行上述查询时，出现以下错误.
无法绑定多部分标识符"tempcte.cj_PaymentMode".

我该如何解决?

While executing the above query i''m getting the following error.
The multi-part identifier "tempcte.cj_PaymentMode" could not be bound.

How can I solve this ?

推荐答案

我猜想，该线程可以解释所有问题:

I guess, this thread explains all: Similar issue discussed and resolved[^]

Known documented issue resolved by Microsoft.

这篇关于错误:无法绑定多部分标识符.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！