We have setup a Join on a unique field between two tables. One table is an SDE polygon feature, the other is a SQL table. We have set up the join to data through an .odc connection to the SQL location. After running the Join, we are noticing that not all records are joining up. After manually comparing the records that have not joined, we cannot find any reason why the join isn't working on these select features. We have manually verified that the records are exactly the same. It is a very perplexing issue.
Has anyone seen this issue of dropped joins when Joining to a SQL table from an SDE feature on a common field?
On a side note, I exported these records out of SQL to a .dbf table, and I am, without any trouble, able to join up with the SDE feature on all records.