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)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment