220
edits
Changes
Jump to navigation
Jump to search
no edit summary
FROM matcherportcomasinclude;
--8655
Recheck the key counts. 1 portco key from the companybase table should match with exactly 1 mas key from the mascore table. If you have more than 1:1 you will get errors in the next phase when you join the companybase table to the mas table.
SELECT COUNT(*) FROM (
SELECT DISTINCT file1coname, file1statecode, file1datefirstinv
FROM matcherportcomascore) AS foo;
--8655
Great! Now you are ready to begin joining the companybase table to the mas table.
==Creating Stage Flags Table==
