474
edits
Changes
Jump to navigation
Jump to search
→Cleaning firmbase
==Cleaning firmbase==
The firmbase table contains undisclosed firms. Add a flag and remove them. Then use firmname, statecode, foundingdate as the key for this table. Check that is valid and make your core table.
CREATE TABLE firmbase1 AS
