[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

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

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
NigelRocks
Asked:
NigelRocks
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:

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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now