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:
SET Gifts.Received=(SELECT RECIPIENTS_GIVERS_TO_GIFTS.RECEIVED
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.