I try to put up a one-to-many relationship between a feature class (one) and a table (many) using MakeQueryTable tool. One entry in the feature class needs to be linked to many entries in the table and I tried to set this up using SQL in the tool (I followed this ESRI article: http://support.esri.com/en/knowledgebase/techarticles/detail/37544):
[Feature_Class].FIELDA = [Table].FIELDB`
The records are matching, it just needs to relate them.
However, it gives me the following error:
could not be retrieved properly. [Table.FIELDB] Failed to execute (MakeQueryTable).
If I try it the other way around, i.e.
[Feature_Class].FIELDB = [Table].FIELDA
could not be retrieved properly. [Table.FIELDA] Failed to execute (MakeQueryTable).
As far as I can tell, everything is in perfect order, i.e. the table and feature class are in the same DB and I added the feature class first to the tool, in the hope to get out a feature class.
Anyone has any idea?