The multi-part identifier could not be bound

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

General SQL Server Forums

New to SQL Server Programming

The multi-part identifier could not be bound

Author

Topic

rob41
Yak Posting Veteran

67 Posts

Posted - 2009-12-28 : 13:06:21

I am trying to run an update script and it gives me the error message multi-part identifier could not be bound?

-sql-
UPDATE [tblCarrierProbyLoad]
SET [tblShipments].[carrier_pro_number]=[tblCarrierProbyLoad].[Carrier_Pro]
FROM [tblCarrierProbyLoad]
INNER JOIN [tblShipments]
ON ([tblCarrierProbyLoad].[load]=[tblShipments].[Load Id])

I thought this was formatted correctly and all of the tables exist?

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-12-28 : 13:11:33

[code]
UPDATE [tblCarrierProbyLoad]
SET [Carrier_Pro]= [tblShipments].[carrier_pro_number]FROM [tblCarrierProbyLoad]
INNER JOIN [tblShipments]
ON ([tblCarrierProbyLoad].[load]=[tblShipments].[Load Id])
[/code]

Jim

Everyday I learn something that somebody else already knew

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources