In model builder, I have a table that when joined to a point feature would have a one-to-many relationship. When using a feature layer in a FGDB and a table in a FGDB, exporting a join between the two results in the one-to-many relationship, meaning more points are exported than existed in the initial point layer. When using in_memory for either the table or the feature layer, the one-to-many relationship is not maintained, and only a single point is exported from the join.
Any ideas? Is this expected behavior and a limit of the in_memory workspace?