Hi,
I amtrying to do a simple update statement but I get the following error message:"The multi-part identifier "a.IDGRP" could not be bound.
"
Do you have any idea what I can do, or am doing worng here?
thank you
Here is my code:
Code:
UPDATE
[NAACOM].[dbo].[APVEN_Test2]
SET a.IDGRP = b.IDGRP
,a.[TEXTSTRE1] = b.[TEXTSTRE1]
,a.[TEXTSTRE2] = b.[TEXTSTRE2]
,a.[TEXTSTRE3] = b.[TEXTSTRE3]
,a.[TEXTSTRE4] = b.[TEXTSTRE4]
,a.[NAMECITY] = b.[NAMECITY]
,a.[CODESTTE] = b.[CODESTTE]
,a.[CODEPSTL] = b.[CODEPSTL]
From [APVEN_Test2] a
INNERJOIN [ADDRESS UPDATE] b
ON a.[VENDORID] = b.[VENDORID]