找不到多部分标识符 [英] The multi-part identifier could not be found

问题描述

sql server中的以下查询

the below query in sql server

SELECT 
  a.firstname,
  a.lastname,
  a.surname,
  G.zonename,
  H.name as zonalheadname,
  F.name as regionalheadname,
  I.statusname as zonalheadapprovestatus,
  J.statusname as regionalheadapprovestatus,  
  K.name as zonalheadapprovename,
  L.name as regionalheadapprovename,
  M.farmer_coopname  
FROM dbo.tbl_farmerregistration_ivorycoast A,
  tbl_farmercooperativesmaster_ivorycoast M
  INNER JOIN dbo.tbl_sectionmaster_ivorycoast N ON N.fieldstaffid =  a.createdby
  INNER JOIN dbo.tbl_zonemaster_ivorycoast G ON G.zoneid = N.zoneid  
  INNER JOIN dbo.tbl_registration H ON H.regid = G.zoneheadid  
  INNER JOIN dbo.tbl_registration F ON F.regid = H.regid  
  INNER JOIN dbo.tbl_approvestatusmaster I ON I.approvestatusid = a.firstlevelapprovalstatus  
  INNER JOIN dbo.tbl_approvestatusmaster J ON J.approvestatusid = a.secondlevelapprovalstatus  
  LEFT JOIN dbo.tbl_registration K ON K.regid = a.firstlevelapprovedby  
  LEFT JOIN dbo.tbl_registration L ON L.regid = a.secondlevelapprovedby  
where  
  a.farmerseason = '2019' and  
  a.farmerctscode = '1176795'

当我在sql server中运行上述查询时显示错误如下



多部分标识符a.createdby无法绑定。

无法绑定多部分标识符a.firstlevelapprovalstatus。

无法绑定多部分标识符a.secondlevelapprovalstatus 。

多部分标识符a.firstlevelapprovedby无法绑定。

多部分标识符a.secondlevelapprovedby无法绑定。



我上面的sql查询中的错误是什么。如何解决这个错误。



我尝试过：



[删除重复内容]

when i run the above query in sql server shows error as follows

The multi-part identifier "a.createdby" could not be bound.
The multi-part identifier "a.firstlevelapprovalstatus" could not be bound.
The multi-part identifier "a.secondlevelapprovalstatus" could not be bound.
The multi-part identifier "a.firstlevelapprovedby" could not be bound.
The multi-part identifier "a.secondlevelapprovedby" could not be bound.

what is the mistake in my above sql query. how to solve this error.

What I have tried:

[REMOVE DUPLICATE CONTENT]

推荐答案

检查表 tbl_farmerregistration_ivorycoast 。 SQL告诉您，您尝试访问的列没有...

Check table tbl_farmerregistration_ivorycoast. SQL tells you that is has no those columns you try to reach...

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