Pacific-Design.com

    
Home Index

1. Databases

2. Create Table

Databases / Create Table /

-- Create distinct npid field from master table

CREATE TABLE docfinderv17.docfinder_master_npid_geolocation
    SELECT DISTINCT npid, geopoint 
    FROM docfinderv17.docfinder_master_fact_geolocation;