Hi, in this video I have shown that you will get improper results by adding join between standalone table and table of a feature class (point, polyline, polygon), so it is better to add join between two standalone tables or between two tables of feature class.
Regards