update DEPT_BK B set DEPTNO = DEPTNO from DEPT A where A.DNAME = B.DNAME
www.ipentec.com
update DEPT_BK3 set LOC = 'test3' where DEPTNO = '10';
select * from DEPT_BK3
update DEPT_BK3 A set DEPTNO = (select B.DEPTNO from DEPT B where A.LOC = B.LOC)
select * from DEPT_BK3 where KOUSHINBI > '2022/10/30'