update t2
set faa_count =(
select count(*) from t1,t3
where t1.fop=a.fop
and t3.fys=t1.fys
and t3.fcc=60
)
from t2 a
set faa_count =(
select count(*) from t1,t3
where t1.fop=a.fop
and t3.fys=t1.fys
and t3.fcc=60
)
from t2 a
set faa_count = (select count(*) from t3,t1 where t3.fys=t1.fys and t1.op=a.op and t3.fcc=60)
from t2 a