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'
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]