SQLdeveloper如何批量修改内链接的这个字段

Question

SELECT lipqoh,limcu,LIITM,IBLITM,ibGLPT from F41021@STDTA a inner join F4102@STDTA b
on a.liitm=b.ibitm
where a.LIITM in (9820195)
and a.lipqoh='0'
and a.limcu in (' 10601')
and b.ibGLPT!='I05'

Answer 1

就跟你想更新元组匹配字段一样，无非就是加了内连接作为删选条件

UPDATE a SET a.ibGLPT = 'I05' 
FROM F41021 a INNER JOIN F4102 b 
ON a.LIITM = b.IBITM 
WHERE a.LIITM IN (9820195) AND a.lipqoh = '0' AND a.limcu IN ('10601') AND b.ibGLPT != 'I05';