Need help with innerjoin where innerjoin returns more rows than necessary

Hi, I am using innerjoin to join two tables A and B: C = innerjoin(A, B); A has 30 rows and B has 140 rows. After the join, the result C has 70 rows. How come? I am quite puzzled. I just wanted 30 rows as in table A with a few extra columns from B. Thanks for any help!

Answer 1

[JFz]

Just found what's wrong here. Table B has same rows multiple times.