353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:42, 25 April 2017
, 16:42, 25 April 2017→Output: ptoassigneend_us_clean1
-- SELECT 2603422
====Output: ptoassigneend_us_clean1ptoassigneend_us_identify1====
This table stores records that meet all the requirements above: zip with 5-4 or 5 digits, state not null or not spaces, and city in ptoasigneend_us_citylist.
SQL Code:
CREATE TABLE ptoassigneend_us_clean1 ptoassigneend_us_identify1 AS
SELECT *
FROM ptoassigneend_us_temp
