The multi-part identifier could not be bound

[fajarjalal]

I tried to execute this coding but an error appeared.

SELECT CMS_INDIVIDUAL.FULL_NAME AS DirectorName, CMS_MASTER_SETUP1.DESCRIPTION AS Suffix,
CMS_INDIVIDUAL.GENDER,CMS_MASTER_SETUP2.DESCRIPTION AS Race, CMS_MASTER_SETUP3.DESCRIPTION AS Prefix, CMS_INDIVIDUAL.DOB, 
CMS_INDIVIDUAL.IC_NEW_NUM, CMS_INDIVIDUAL.IC_OLD_NUM, CMS_INDIVIDUAL.PASSPORT_NUM AS passport,
CMS_MASTER_COUNTRY.NATIONALITY_NAME AS Nationality, CMS_DIRECTORSHIP.DIRECTOR_ACTOR_GUID,CMS_MASTER_SETUP4.DESCRIPTION AS DirectorOccupation,  
CMS_MASTER_SETUP6.DESCRIPTION AS Designation, CMS_DIRECTORSHIP.DIRECTOR_PK,CMS_MASTER_SETUP5.DESCRIPTION AS ICColor 
FROM CMS_DIRECTORSHIP INNER JOIN CMS_INDIVIDUAL ON CMS_DIRECTORSHIP.DIRECTOR_ACTOR_GUID = CMS_INDIVIDUAL.IND_ACTOR_GUID LEFT OUTER JOIN 
CMS_MASTER_SETUP CMS_MASTER_SETUP6 ON CMS_MANAGER.DESIGNATION_GUID = CMS_MASTER_SETUP6.MASTER_SETUP_PK LEFT OUTER JOIN
CMS_MASTER_SETUP CMS_MASTER_SETUP5 ON CMS_INDIVIDUAL.IC_OLD_COLOR_GUID = CMS_MASTER_SETUP5.MASTER_SETUP_PK LEFT OUTER JOIN
CMS_MASTER_SETUP CMS_MASTER_SETUP4 ON CMS_INDIVIDUAL.BUSINESS_OCCUPATION_GUID = CMS_MASTER_SETUP4.MASTER_SETUP_PK LEFT OUTER JOIN 
CMS_MASTER_COUNTRY ON CMS_INDIVIDUAL.NATIONALITY_GUID = CMS_MASTER_COUNTRY.COUNTRY_PK LEFT OUTER JOIN CMS_MASTER_SETUP CMS_MASTER_SETUP3 ON
CMS_INDIVIDUAL.PREFIX_GUID = CMS_MASTER_SETUP3.MASTER_SETUP_PK LEFT OUTER JOIN 
CMS_MASTER_SETUP CMS_MASTER_SETUP2 ON CMS_INDIVIDUAL.RACE_GUID = CMS_MASTER_SETUP2.MASTER_SETUP_PK LEFT OUTER JOIN  
CMS_MASTER_SETUP CMS_MASTER_SETUP1 ON CMS_INDIVIDUAL.SUFFIX_GUID = CMS_MASTER_SETUP1.MASTER_SETUP_PK
WHERE (CMS_MANAGER.ORG_ACTOR_GUID = '" & recSet!ORG_ACTOR_GUID & "') AND (CMS_MANAGER.DATE_OF_CESSATION IS NULL) AND (CMS_DIRECTORSHIP.ORG_ACTOR_GUID = '" & recSet!ORG_ACTOR_GUID & "') AND (CMS_DIRECTORSHIP.DATE_OF_CESSATION IS NULL)  
ORDER BY CMS_DIRECTORSHIP.ORDER_NUM

the error is

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "CMS_MANAGER.DESIGNATION_GUID" could not be bound.

can somebody help me?

[hspc]

CMS_MANAGER is not referenced. it's not in the joins or the from clause. And it's not an alias to any table used in the query.