quote:

---

Originally posted by LuckyJim

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 mf 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'
)

---

--------- 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'
)