select语句中的问题：多部分标识符...... [英] problem in select statement: The multi-part identifier ...

问题描述

sql语句是：

sql statement is :

SELECT
	distinct MaintRequest_tbl.*,
	Employees_tbl.txt_NameE as txt_empName,
	Customer_tbl.txt_AddressE as txt_address,
	Customer_tbl.txt_Tel1 as txt_telNum,
	Customer_tbl.txt_fax,
	Customer_tbl.txt_Email,
	Customer_tbl.txt_CellTel,
	Customer_tbl.int_type,
	Accessories_tbl.txt_acc
FROM
	MaintRequest_tbl,
	soldMachine_tbl
		LEFT JOIN
		Employees_tbl
		ON
		(MaintRequest_tbl.txt_assignEmpCode=Employees_tbl.txt_Code)
		LEFT JOIN
		Customer_tbl
		ON
		(Customer_tbl.txt_custCode=MaintRequest_tbl.txt_custCode)
		LEFT JOIN
		Accessories_tbl
		ON
		(Accessories_tbl.txt_pCode='A'
	AND
	Accessories_tbl.int_vNum=11853)
WHERE
	MaintRequest_tbl.txt_pCode='A'
	AND
	MaintRequest_tbl.int_vNum=11853
	AND
	MaintRequest_tbl.txt_sMachCode = soldMachine_tbl.txt_code

错误信息是：

An error message is:

The multi-part identifier "MaintRequest_tbl.txt_assignEmpCode" could not be bound.

推荐答案

根据问题的评论，检查你的SQL查询语法。



如需了解更多信息，请参阅：

MSSQLSERVER_4104 [ ^ ]

SQL执行错误。无法绑定多部分标识符.... [ ^ ]

As per comments to the question, check your sql query syntax.

For further information, please see:
MSSQLSERVER_4104[^]
SQL Execution Error. The multi-part identifier ... could not be bound.[^]

这篇关于select语句中的问题：多部分标识符......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！