AnsweredAssumed Answered

ArcMap Join Field tool produces different results than Join Data?

Question asked by jfengineer2 on Jan 30, 2017
Latest reply on Feb 1, 2017 by jfengineer2

When using ArcMap 10.4.1 with SQL 2012/ArcSDE 10.4.1, I have a case where the Join Field tool does not join some related rows, even though the field values appear to be identical (specifically, a SQL join using Transact-SQL matches the related rows as I expected).  If, on the other hand, I use the Join Data tool, it works as expected.  I would prefer to use Join Field because it is directly supported in Model Builder.

Outcomes