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