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)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)