Great Community! I've learned a ton reading through other's post's and answers. Hopefully someone can help me with this.
If I load 2 tables that join by an ID but have ID sets that don't overlap fully, the extra IDs from the second table seem to be ignored when using set operators on alternate states. I've attached an example file showing the inconsistency.
It seems like I could get around this behavior by doing some fancy loading (force the 2 tables together, or add the IDs from the second table to the first table, etc.) But I'd like to understand why this happens in the first place. Since it seems like in a normal application if I loaded tables that weren't perfectly matched in the wrong order I'd end up with this issue. Any ideas on how to solve this with out doing fancy loading stuff?