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

x
?
Solved

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

Posted on 2009-05-02
3
Medium Priority
?
1,532 Views
Last Modified: 2012-05-06
Hi,

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
BEGIN TRAN
Update clientes SET gerente_atual = gerentes.cod WHERE gerente_atual = gerentes.nome
COMMIT

Open in new window

0
Comment
Question by:marcoloppo
  • 2
3 Comments
 
LVL 41

Expert Comment

by:ralmada
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'  
0
 
LVL 41

Accepted Solution

by:
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

0
 

Author Closing Comment

by:marcoloppo
ID: 31577252
Ralmada,

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

Marco
0

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