Many-To-Many join

[romanzdk]

Hello, how to join 2 tables with many to many relationship? Regular join tool joins only on first occurence.

Thank you

[BrandonB]

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

[romanzdk · Accepted solution]

Thank you, you are right. The problem was case in the columns (join is case sensitive).