Keep getting "Ambiguous name in query expresion" error

Hello,
I keep getting the error "Ambiguous name in query expresion. 'Swap([Diamond]'. When I try to execute the following query.  It's telling me that there is a mispelling or something of that nature.  What am I missing?

UPDATE STAGE_INST_HDR SET STAGE_INST_HDR.ALIAS = Swap([Diamond Id])
WHERE ((Not (STAGE_INST_HDR.[Diamond Id]) Is Null));
Juan VelasquezAsked:
Who is Participating?
 
sdstuberCommented:
DO you have multiple objects named Diamond Id?


if so, dereference it from the table as you did in the where clause



UPDATE STAGE_INST_HDR SET STAGE_INST_HDR.ALIAS = Swap(STAGE_INST_HDR.[Diamond Id])
WHERE ((Not (STAGE_INST_HDR.[Diamond Id]) Is Null));
0
 
Juan VelasquezAuthor Commented:
I found the solution.  There were two functions with the same name.  I removed one and it works
0
 
Juan VelasquezAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for chtullu135's comment http:/Q_27420757.html#37047839

for the following reason:

I found the problem on my own.  I discovered that there were two functions with the identical name.  When I removed one of them, the query works
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
sdstuberCommented:
>>>> two functions with the same name

isn't that what was originally suggested?
0
 
South ModModeratorCommented:
sdstuber suggested exactly that in their first comment: "Do you have multiple objects named Diamond ID". As such, I've accepted that comment as the solution.

SouthMod
Community Support Moderator
0
 
Juan VelasquezAuthor Commented:
I had multiple objects named Swap not diamond id but I get your point.
0
 
Juan VelasquezAuthor Commented:
I've accepted sdtubers suggestion
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.