Ambiguous column name 'Email_Address'

Tagged:

Currently contains 3 posts

Avatar

April 01, 2019 05:10

brianjlowry

Hi,

We’ve been grabbing Name records with very few issues for the past few months, though very recently we started receiving this error:
“Ambiguous column name ‘Email_Address’”

It appears to be tied directly to (at least) two email addresses – if we manually run the query in the browser and remove those two, everything works fine.

I’ve looked at the records and can’t find anything obvious.

Any ideas?

Thanks,
Brian

Avatar

April 01, 2019 15:22

Jarrid-PCRecruiter

Hi Brian,

I would need to know the user credentials as well as the (GET) request you’re using. You can email them to jarrid ( @ ) mainsequence.net and I’ll be able to look into the issue further for you. Ambigous column name itself is a SQL error meaning that there are 2 (or more) columns, with the same name, being returned and it’s not sure which one(s) you want (have to specify table or alias name).

Jarrid

Avatar

April 01, 2019 15:50

brianjlowry

Thanks for your help, Jarrid! I will send that over shortly.

Reply to thread