I have recently been trying to join a database table (AfricaTable) to a feature class(Africa_Shape). Both are in the same personal gdb (as I am lead to believe this is the correct format, from the tutorial I have tried to follow). The database table has the following relevant fields: ObjectID, Country (Text), Date (Date), and a "Present" (Double). The feature class has the following relevant fields: ObjectID, GID (Text), Name_0 (Text).
When I am using the tool, I add both the feature class and the table as the inputs. I am joining with an expression that the "AfricaTable.Country" = "Africa_Shape.NAME_0" (I have tried this with "..." '...' and nothing). When I verify the expression it verifies, but says no records are found. I have attached images showing both the table, feature class, and the tool parameters.
Ideally I am wanting the Africa shapefile, in the format of the table. So hopefully I can put it into a time animation of whether conservation efforts have been present in certain countries throughout the years.
Thanks in advance for your comments, questions and suggestions.
Sam.
Solved! Go to Solution.
For personal geodatabases, you need to have square brackets around database object names, have you tried:
[AfricaTable].[Country] = [Africa_Shape].[NAME_0]
For personal geodatabases, you need to have square brackets around database object names, have you tried:
[AfricaTable].[Country] = [Africa_Shape].[NAME_0]
Hi Joshua, thanks for your reply. I just tried your suggestion, it worked a treat.