[Home] [Help]
View: PAY_US_NEW_CITIES_V
View Text
SELECT ZP.ROWID ZPROW_ID
, CI.ROWID CIROW_ID
, GE.ROWID GEROW_ID
, ZP.STATE_CODE
, ZP.CITY_CODE
, ZP.COUNTY_CODE
, ST.STATE_NAME STATE_NAME
, ST.STATE_ABBREV
, CO.COUNTY_NAME COUNTY_NAME
, CI.CITY_NAME CITY_NAME
, ZP.ZIP_START
, ZP.ZIP_END
, CI.DISABLE
FROM PAY_US_STATES ST
, PAY_US_COUNTIES CO
, PAY_US_CITY_NAMES CI
, PAY_US_ZIP_CODES ZP
, PAY_US_CITY_GEOCODES GE
WHERE ZP.STATE_CODE = ST.STATE_CODE
AND ZP.STATE_CODE = CO.STATE_CODE
AND ZP.COUNTY_CODE = CO.COUNTY_CODE
AND ZP.STATE_CODE = CI.STATE_CODE
AND ZP.COUNTY_CODE = CI.COUNTY_CODE
AND ZP.CITY_CODE = CI.CITY_CODE
AND ZP.STATE_CODE = GE.STATE_CODE
AND ZP.COUNTY_CODE = GE.COUNTY_CODE
AND ZP.CITY_CODE = GE.CITY_CODE
AND CI.STATE_CODE = GE.STATE_CODE
AND CI.COUNTY_CODE = GE.COUNTY_CODE
AND CI.CITY_CODE = GE.CITY_CODE
AND CO.STATE_CODE = GE.STATE_CODE
AND CO.COUNTY_CODE = GE.COUNTY_CODE
AND ST.STATE_CODE = GE.STATE_CODE --ORDER BY ST.STATE_NAME
Columns
Name |
ZPROW_ID |
CIROW_ID |
GEROW_ID |
STATE_CODE |
CITY_CODE |
COUNTY_CODE |
STATE_NAME |
STATE_ABBREV |
COUNTY_NAME |
CITY_NAME |
ZIP_START |
ZIP_END |
DISABLE |