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
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
|
|
|