dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: The multi-part identifier could not be bound

  1. #1
    Join Date
    Jul 2011
    Posts
    9

    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?

  2. #2
    Join Date
    Apr 2002
    Location
    Egypt
    Posts
    2,210

    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.
    Hesham A. Amin
    My blog , Articles


    <a rel=https://twitter.com/HeshamAmin" border="0" /> @HeshamAmin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)