none
"The multi-part identifier ... could not be bound" on MERGE statement RRS feed

  • Question

  • Hi! This MERGE statement causes the following errors:

    • The multi-part identifier "KSystem37.Malli_tuotenumero" could not be bound.
    • The multi-part identifier "KSystem37Update.Malli_tuotenumero" could not be bound.

    What's wrong? Thanks for helping!

    Harri


    Friday, October 5, 2012 9:40 AM

Answers

  • you aliased it with name target and source , so you to use aliases whenever you reference your table again in that query like

    Target."Toimintotunnus"=Source."Toimintotunnus"


    Thanks and regards, Rishabh K

    • Marked as answer by Haba7 Friday, October 5, 2012 10:11 AM
    Friday, October 5, 2012 9:44 AM

All replies

  • you aliased it with name target and source , so you to use aliases whenever you reference your table again in that query like

    Target."Toimintotunnus"=Source."Toimintotunnus"


    Thanks and regards, Rishabh K

    • Marked as answer by Haba7 Friday, October 5, 2012 10:11 AM
    Friday, October 5, 2012 9:44 AM
  • Thanks, it works now!
    Friday, October 5, 2012 10:11 AM