One-to-One Join by States only joining Wyoming

[Craig_Eissler_Iceman]

Hello,

I have several students (but not all) who are attempting to do a very basic one-to-one join of US States with a simple Census demographic table, using the 'Name' field in each -- which of course is the State name. The result is only one match; Wyoming.

The data looks fine to me, and both 'Name' fields are "Text". However, I do notice that both of those are  "indexed" as indicated by the asterisk (*).

See attached Geodatabase.

Could that be the problem? If not, what else should we check?
p.s. I tried to remove that index, but it didn't work, or I'm not doing it correctly

Thanks, Craig E.

[BarryNorthey]

Using the data that you provided as delivered, the joined fields were added but I got NULL values in all joined fields. I copied the feature class and table to another FGDB (Home) and Add Join worked correctly. Don't know why.

[Craig_Eissler_Iceman · Accepted solution]

Interesting. I just tried that and it worked for me, as well! ...hmmm