220
edits
Changes
Jump to navigation
Jump to search
→Creating portcokey, roundline, firm table
\COPY portcoexitmaster TO 'portcoexitmaster.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
==Creating portcoroundlinefirmmaster==portcoroundlinefirmmaster table contains portcokey, roundline, firm table. CREATE TABLE portcoroundlinefirmmaster AS SELECT c.coname, c.statecode, c.datefirstinv, r.rounddate, r.amountk, r.fundname, f.firmname FROM companybasecore AS c INNER JOIN roundline AS r ON c.coname = r.coname AND c.statecode = r.statecode AND c.datefirstinv = r.datefirstinv INNER JOIN fundbasecore AS fu ON fu.fundname =r.fundname INNER JOIN firmbasecore AS f ON f.firmname =fu.firmname; --299321
==Joining funds, firms, roundline with companybasecore==
