220
edits
Changes
Jump to navigation
Jump to search
The queries below build your companybasecore table. The where clause takes the place of the 2 flags on nationcode and undisclosed company we built in companybase1 table. This table has a guaranteed 1:1 relationship between coname, statecode, datefirstinv and an entry in the table. The two queries at the end verify this. We use core tables to run joins later on.
→companybasecore table
==companybasecore table==
DROP TABLE companybasecore;
CREATE TABLE companybasecore AS
