postgis update query where there is an intersection

st_intersect_query.sql

update census_tracts_2014
set council_district = t1.dist
from (select council_districts.dist, census_tracts_2014.affgeoid, council_districts.geom 
from census_tracts_2014 inner join council_districts 
on
ST_Intersects(census_tracts_2014.geom, ST_Transform(council_districts.geom,4269))) t1 
where 
ST_Intersects(census_tracts_2014.geom, ST_Transform(t1.geom,4269));