Solved

The multi-part identifier <Identifier> could not be bound

Posted on 2007-11-17
1
434 Views
Last Modified: 2008-02-01
Hello,

I'm trying to update one table column with the values in another table's column of the same name.  I'm getting the error:

The multi-part identifier "Gifts.Gift_ID" could not be bound.

This is the query:

UPDATE Gifts
SET Gifts.Received=(SELECT RECIPIENTS_GIVERS_TO_GIFTS.RECEIVED
                              FROM RECIPIENTS_GIVERS_TO_GIFTS
                              WHERE Gifts.Gift_ID=RECIPIENTS_GIVERS_TO_GIFTS.Gift_ID)

The "Gift_ID" is causing a problem in both tables, depending how I word the query.  This must have something to do with the ID key and foreign key relationship.  At this point, I'm only executing the sub-query, so the outlying query is not in play.

The GIFT_ID field in both tables is a smallint.

Any ideas?
0
Comment
Question by:NigelRocks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 20306491

UPDATE G
SET Received=rg.RECEIVED
FROM Gifts g
INNER JOIN  RECIPIENTS_GIVERS_TO_GIFTS rg
ON G.Gift_ID=RG.Gift_ID
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

623 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