Solved! Go to Solution.
The Join tool will join on every occurrence. For example, when joining these two example tables on the Fruit column.
Table 1:
Fruit Quantity
Apple 2
Apple 3
Table 2:
Fruit Color
Apple Red
Apple Green
Will result in:
Fruit Quantity Fruit Color
Apple 2 Apple Red
Apple 2 Apple Green
Apple 3 Apple Red
Apple 3 Apple Green
Thank you, you are right. The problem was case in the columns (join is case sensitive).