Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    20

    Unanswered: Multi-part identifier <alias.column> could not be bound in UPDATE

    Hi all,

    Have looked at all the posts to do with this but none seem applicable

    Get this error msg when I run the code
    The multi-part identifier "mf.m9rewh" could not be bound.

    If I remove the UPDATE and SET and replace with SELECT it all works fine.

    Hoping someone can kick me in the right direction

    Here is the code

    --------- Start of Code -----------------------
    UPDATE mitfac
    SET mf.m9rewh = 'TEST'
    FROM
    mitfac AS mf
    INNER JOIN
    mitmas as mm
    ON
    (
    mm.mmitno = mf.m9itno
    AND
    mm.mmitno = 'E6808000001999A'
    AND
    mf.m9rewh = 'L12'
    AND
    mm.mmitcl = 'ICB'
    )

    ---------------- End of Code --------------------------------------

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Removing ALL aliases will sort it out but in particular remove the alias from SET....
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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