The multi-part identifier "Loads.STREET Name" could not be bound.

[Anthony97]

I'm getting this code to complie fine, the problem begins win I try and execute it? I'm stuck.



UPDATE [Loads]
SET [tblMaster_Loads _44].[Destination Plant] = [tblPlants].[Plant]
FROM [Loads]

INNER JOIN [tblPlants]
ON [Loads].[STREET Name] = [tblPlants].[STREET Name]
INNER JOIN [tblMaster_Loads _44]
ON [Loads].[Master Load Number] = [tblMaster_Loads _44].[Master Load No]
WHERE [tblMaster_Loads _44].[Destination Plant] Is Null;

[ck9663]

I have not tried if your query will work. The table on the FROM clause is different from the actual target of your update in the SET clause. Try to check your syntax here...


Good Luck!!!

~~ CK