Wednesday 12 June 2019

Oracle Update Table from Table

update SCHOOLS
set (SCHOOLS.LOWEST_CLASS, SCHOOLS.HIGHEST_CLASS) = (select  AAAA_DIRECT.lowest_class, AAAA_DIRECT.HIGHEST_CLASS
from AAAA_DIRECT
where SCHOOLS.ID = AAAA_DIRECT.STDID)