Just found what's wrong here. Table B has same rows multiple times.
Need help with innerjoin where innerjoin returns more rows than necessary
2 views (last 30 days)
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!