220
edits
Changes
Jump to navigation
Jump to search
→Joining companybasekeys with maskeys and ipokeys
WHERE ipoissuedate IS NOT NULL AND announceddate IS NOT NULL;
--83
Now you can successfully join the companybasecore table to the ipocore and mascore tables through the companybasekeyipokeycore and companybasekeymaskeycore tables. With this step done you can create a master table which will contain information from companybase and ipo and mas.
==Creating portcotransactionmaster table==
==Name Based Matching companybase keys to ipo keys==
