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

multi-part identifier could not be bound

Author

Topic

Trudye
Posting Yak Master

169 Posts

Posted - 2009-07-07 : 19:18:49

I am receiving the error:
The multi-part identifier could not be bound. Here is the code:

UPDATE dbo.tbl_fees
SET dbo.tbl_fees.TRCODE = DDTRNF.TRCODE,
dbo.tbl_fees.TRDATE = DDTRNF.TRDATE
From DDTRNF INNER JOIN dbo.tbl_fees
ON DLOAN = TLOAN

Not sure what the problem is.
Thank you

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2009-07-07 : 19:23:30

try this:

UPDATE 
	Fees
SET 
	TRCODE = DDTRNF.TRCODE, 
	TRDATE = DDTRNF.TRDATE 
From 
	DDTRNF 
INNER JOIN 
	dbo.tbl_fees AS Fees
	ON DLOAN = TLOAN

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources