158
edits
Changes
Jump to navigation
Jump to search
→Process For Creating the PortCoExits Table
JOIN MAClean AS B ON A.coname=B.coname AND A.statecode=B.statecode AND A.datefirstinv=B.datefirstinv;
I then wrote a query to check which date was lower and used that to indicate whether I chose the company to have undergone an MA or an IPO in the column MSvsIPO(I chose based on which process came first). A 0 in the column represented an MA being chosen and a 1 represented an IPO being chosen.
DROP TABLE IPOMASelected;
CREATE TABLE IPOMASelected AS
