My problem is, that after the joining the ID 1212 will be doubled as there are two groups (Banana and Apple) possible. Now if I sum the prices of the different IDs, the result of ID 1212 is wrong cause of the problem.(17,40 +17,40)
Do you have an idea how to solve this problem? Can I use another join, so that e.g. Apple is not joined and only banana :-) ??
If you need further information, just let me know!