220
edits
Changes
Jump to navigation
Jump to search
→Joining firms with funds
--2364
==Joining firms with funds==
DROP TABLE firmfundstestjoin;
CREATE TABLE firmfundstestjoin AS
SELECT f.firmname AS firmfirmname, fu.firmname AS fundsfirmname
FROM firmbasecore AS f
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==
