220
edits
Changes
Jump to navigation
Jump to search
--To check if you have the correct number of ipo and mas keys add the two counts from your query above and the count from the query below and compare it to the number of keys in your companybasemaskeycore and companybaseipocore table. In my case I get 8610 + 2312 + 83 = 2350 - 2312 = 38, + 8655 - 8610 = 45, 45+38 = 93 . SELECT COUNT(hm something went wrong*) FROM companybasekeysaddmaskeysaddipokeys WHERE ipoissuedate IS NOT NULL AND announceddate IS NOT NULL; --83
→Joining companybasekeys with maskeys and ipokeys
--2312
==Name Based Matching companybase keys to ipo keys==
