Problem With Mass Update From One Table To Another

[dwg23]

Hello,
I need to update the Description Column in the Item table on my server from the Futura table.
I have written the below code and it continues to fail. from what I can see it should all be good but it is not.

Here is the code.

UPDATE tblimItem
SET [tblimItem.Description] = [Futura.Description]
FROM tblimItem
INNER JOIN Futura
ON (tblimItem.Item = Futura.Item)

I get several failures in the query but they should all be good.
tblimItem.Description is a Invalid column name as is Futura.Description
also get an error of incalid object name 'futura' "On tblimItem.Item" comes out as Invalid Column Name and finally futura.item says the multipart Inentifier could not be found.

Can you help.

 

[gmmastros]

Your square brackets are wrong.

UPDATE tblimItem
SET [tblimItem].[Description] = [Futura].[Description]
FROM tblimItem
INNER JOIN Futura
ON (tblimItem.Item = Futura.Item)

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[dwg23]

Gmastros,
Thanks! That did it!

Thanks again,
Dwg23