schools join

join-tmsch.sql

(select 
OGC_FID,
GEOMETRY,
t.stnam,
t.schnam,
t.fipst,
t.leanm,
t.leaid,
t.ncessch,
change,
grade,
pct_gradrate07,
pct_gradrate08,
pct_gradrate09,	
all_gradrate09,
all_gradrate08,
all_gradrate07,
all_read04_0910,
all_read08_0910,
all_read10_0910,
all_read12_0910,
all_read04_0809,	
all_read08_0809,
all_read10_0809,
all_read12_0809,
all_read04_0708,
all_read08_0708,
all_read10_0708,
all_read12_0708,
all_math04_0910,
all_math08_0910,
all_math10_0910,
all_math12_0910,
all_math04_0809,
all_math08_0809,
all_math10_0809,
all_math12_0809,
all_math04_0708,
all_math08_0708,
all_math10_0708,
all_math12_0708,
lea_read04_0910,
lea_read08_0910,
lea_read10_0910,
lea_read12_0910,
lea_math04_0910,
lea_math08_0910,
lea_math10_0910,
lea_math12_0910,
chg_math04_0910,
chg_math08_0910,
chg_math10_0910,
chg_math12_0910,
chg_read04_0910,
chg_read08_0910,
chg_read10_0910,
chg_read12_0910,
e12,
e10,
e08,
e04	
from tmsch t
left join ed_data.clean_sch a on a.NCESSCH07 = t.ncessch)