multi-part identifier issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

multi-part identifier issue

Author

Topic

rob41
Yak Posting Veteran

67 Posts

Posted - 2010-03-04 : 16:27:28

the SQL Code compiles fine, when i run it I'm getting the following error: The multi-part identifier "tblMaster_Loads_44.Destination Plant" could not be bound.

here's the code

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;

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-03-04 : 17:01:12

Which table do you want to update?
You say UPDATE [Loads], but you are updating the field [Destination Plant] from a different table [tblMaster_Loads_44]?

Maybe this?

UPDATE a
SET a.[Destination Plant] = c.[Plant]
FROM [tblMaster_Loads_44]  a
INNER JOIN [Loads] b on a.[Master Load No] = b.[Master Load Number]
INNER JOIN [tblPlants] c on c.[STREET Name] = a.[STREET Name] 
WHERE a.[Destination Plant] Is Null