Multi-part identifier could not be bound on UPDATE SQL statement with multiple JOINs

I am at a loss here.  I have read multiple posts on this, but I can't seem to figure out where I am going wrong.  The only thing I can figure is that I am somehow not stating the INNER JOIN correctly.  The JOIN should be that the two tables must match by LOC and ITEM in order for the update to take place.  Here is my SQL attempt at doing this UPDATE:

UPDATE [SL01 MW01 Clean Up Records]
SET New_Sources.dbo_a1_5_SRC1_ID = [SL01 MW01 Clean Up Records].[SRC1_ID], New_Sources.Vendor_id = [SL01 MW01 Clean Up Records].[Vendor_id]
FROM [SL01 MW01 Clean Up Records]
INNER JOIN New_Sources ON ([SL01 MW01 Clean Up Records].dbo_a1_1_LOC = New_Sources.LOC)
AND ([SL01 MW01 Clean Up Records].ITEM = New_Sources.ITEM)

I just keep gettiing the following error message when I execute it:
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "New_Sources.dbo_a1_5_SRC1_ID" could not be bound.

Help please.

Thanks,
Matt
dabdowbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:

UPDATE New_Sources
SET New_Sources.dbo_a1_5_SRC1_ID = [SL01 MW01 Clean Up Records].[SRC1_ID], New_Sources.Vendor_id = [SL01 MW01 Clean Up Records].[Vendor_id]
FROM [SL01 MW01 Clean Up Records]
INNER JOIN New_Sources ON ([SL01 MW01 Clean Up Records].dbo_a1_1_LOC = New_Sources.LOC)
AND ([SL01 MW01 Clean Up Records].ITEM = New_Sources.ITEM)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dabdowbAuthor Commented:
HOLY BRAIN FART!!!!!!!!!!!!!!!!!  LOL!!!!  Thanks for the help aneeshattingal.  I think that is my cue to call it a day!
Cheers,
Matt
0
dabdowbAuthor Commented:
Sometimes just a different set of eyes helps you find the OBVIOUS!  Thanks again!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.