Changes

SELECT fundname, firstinvdate, firmname

FROM fundbasecore;

\COPY fundkeysandfirms TO 'fundkeysandfirms.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

FROM firmbasecore;

\COPY firmkeys TO 'firmkeys.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

CREATE TABLE matcherfirmsfunds (

\COPY matcherfirmsfunds FROM 'matcheroutputfundsfirms.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

--2364

==Joining firms with funds==

DROP TABLE firmfundstestjoin;