Changes

INNER JOIN fundbasecore AS fu ON f.firmname = fu.firmname WHERE fu.firmname != 'Undisclosed Firm';

If you do the full join you will notice that there are 30 firms in the funds table that do not exist in the firms table.

==Cleaning roundline==