I have three features with the same ID, let's say "5". I also have a corresponding text table containing IDs among other info (for example a "category" value). I want to join the table with the features using the ID so that every feature has the same info from the text table. The problem is that only one feature gets joined, and the others are left out. How can I do the join properly?
EDIT: Image for more clarity.
Desired shape attribute result: