[Home] [Help]
View: PAY_US_SCHOOL_DSTS
View Text
SELECT STATE_CODE
, COUNTY_CODE
, '0000' CITY_CODE
, SCHOOL_DST_CODE
, SCHOOL_DST_NAME
FROM PAY_US_COUNTY_SCHOOL_DSTS UNION SELECT STATE_CODE
, COUNTY_CODE
, CITY_CODE
, SCHOOL_DST_CODE
, SCHOOL_DST_NAME
FROM PAY_US_CITY_SCHOOL_DSTS
Columns
Name |
STATE_CODE |
COUNTY_CODE |
CITY_CODE |
SCHOOL_DST_CODE |
SCHOOL_DST_NAME |