17,377
社区成员
发帖
与我相关
我的任务
分享
update tbl1 A
set A.Status = 'S'
where exists(
select 1
from tbl2 H
where A.no = H.no
and A.Amount = H.Amount
and A.Status = H.Status)
--
update tbl2 H
set H.status='S'
where exists(
select 1
from tbl1 A
where H.no=A.no
and H.amount=A.amout
and H.status=A.status)