[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How to fix "The multi-part identifier ... could not be bound" SQL Server 2008 error message?

Posted on 2009-05-02
Medium Priority
Last Modified: 2012-05-06

I'm facing the error message "The multi-part identifier 'gerentes.nome' could not be bound" when I try to run the code below in the Microsoft SQL Server Studio Management. I have two tables and I want simply update data between them.

What might be the problem and how it might be fixed?

Thank you
Update clientes SET gerente_atual = gerentes.cod WHERE gerente_atual = gerentes.nome

Open in new window

Question by:marcoloppo
  • 2
LVL 41

Expert Comment

ID: 24287848
That usually happens when you have a typo in your field name or ALIAS. check and double check your script for correct spelling:
Specially: 'gerentes.nome'  
LVL 41

Accepted Solution

ralmada earned 2000 total points
ID: 24287858
Also check the way you join the tables, it should be like this:

Update clientes 
SET clientes.gerente_atual = gerentes.cod 
from clientes 
inner join gerentes on clientes.gerente_atual = gerentes.nome

Open in new window


Author Closing Comment

ID: 31577252

Thank you for your attention, your solution worked really fine.
The problem was the missing "inner join" parameter.


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question