Forum Discussion
why does the result change on a Table.NestedJoin/JoinKind.Inner regarding which table is 1st or 2nd?
Hello, I do an inner nested join on 2 tables A and B like this : Table.NestedJoin(A, {"UserName"}, B, {"UserName"}, "B", JoinKind.Inner) Just for "the fun", I did also Table.NestedJoin(B, {"User...
I have actually noticed that the number that differs is the number of UserName doubloons there are in my table B. But still, why does it give a different result with Inner, wether I place table A or B in the 1st or 2nd place in the method shouldn't change the result I think. Can you explain to me the logic of it please ?