我对这种在MS Access 中运行良好的语法知之甚少
UPDATE (Table1 INNER JOIN Table2 ON (Table1.IDENT = Table2.IDENT) AND (Table1.AREA = Table2.AREA))
INNER JOIN Table3 ON (Table2.IDENT = Table3.IDENT) AND (Table2.AREA = Table3.AREA)
SET Table3.ELEV = Table2.elev, Table3.NAME = Table2.name, Table3.CYCLE = "1807";
我正在寻找与此等效的 Oracle。
像这样的东西，也许？
UPDATE table3 t3
SET (t3.elev, t3.name, t3.cycle) =
(SELECT t2.elev, t2.name, '1807'
FROM table2 t2
JOIN table1 t1
ON t1.ident = t2.ident
AND t1.area = t2.area
WHERE t2.ident = t3.ident
AND t2.area = t3.area);
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句