update B
set acbl=A.acbl
from
A,B
where
A.empl_no=B.empl_no
and
A.dept=B.dept
and
A.utno=B.utno
and
A.anditem=B.anditem
and
A.cyno=B.cyno
and
A.inrt=B.inrtinsert into B
select
*
from
A
where
not exists(select
1
from
B
where
empl_no=B.empl_no
and
dept=A.dept
and
utno=A.utno
and
anditem=A.anditem
and
cyno=A.cyno
and
inrt=A.inrt)
set acbl=A.acbl
from
A,B
where
A.empl_no=B.empl_no
and
A.dept=B.dept
and
A.utno=B.utno
and
A.anditem=B.anditem
and
A.cyno=B.cyno
and
A.inrt=B.inrtinsert into B
select
*
from
A
where
not exists(select
1
from
B
where
empl_no=B.empl_no
and
dept=A.dept
and
utno=A.utno
and
anditem=A.anditem
and
cyno=A.cyno
and
inrt=A.inrt)
from 表B b,表A a
where b.empl_no=a.empl_no and b.dept=a.dept and b.utno=a.utno and b.item=a.item and b.cyno=a.cyno and b.inrt=a.inrtinsert 表B
select * from 表A a
where not exists(select 1 from 表B b where b.empl_no=a.empl_no and b.dept=a.dept and b.utno=a.utno and b.item=a.item and b.cyno=a.cyno and b.inrt=a.inrt
)