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

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

Answer 1

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

Answer 2

Thanks, it works now!