Changes

Venture Capital (Data) (view source)

464 bytes added , 13:44, 11 July 2017

--44773

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

Now join with the iposnoduplicates table to grab proceedamt and principalamt, etc.

DROP TABLE portcoipojoinamt;

CREATE TABLE portcoipojoinamt AS

SELECT portcoipojoin.*, ipo.principalamt, ipo.proceedsamt, ipo.naiccode, ipo.zipcode, ipo.status, ipo.foundeddate, ipo.pkey

FROM portcoipojoin LEFT JOIN iponoduplicates AS ipo ON portcoipojoin.file2issuer = ipo.issuer AND

portcoipojoin.file2issuedate = ipo.issuedate AND portcoipojoin.statecode = ipo.statecode;

DROP TABLE portcoipojoinmajoin;

220

edits