-
July 26th, 2011, 10:26 PM
#1
The multi-part identifier could not be bound
I tried to execute this coding but an error appeared.
Code:
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?
-
July 30th, 2011, 04:44 AM
#2
Re: The multi-part identifier could not be bound
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|