oracle两张表关联更新
UPDATE detail a
SET settle_status = ‘7777’
WHERE EXISTS
(SELECT 1
FROM abc b
WHERE b.oppaccno = a.cracc_no
)
oracle两张表关联更新
UPDATE detail a
SET settle_status = ‘7777’
WHERE EXISTS
(SELECT 1
FROM abc b
WHERE b.oppaccno = a.cracc_no
)
发表评论