我正在尝试使用 Join 更新金额，但出现异常：
UPDATE tab1
SET tab1.total_adjusted_cost = tab1.total_adjusted_cost + t1.total
FROM table1 tab1,
(SELECT tab3.name, tab3.add, SUM(tab2.amount) AS total
FROM table2 tab2,
table3 tab3,
table4 tab4
WHERE tab2.id = tab3.id
AND tab3.id = tab4.id
AND tab4.indicator = 'Y'
GROUP BY tab3.name, tab3.add ) t1
WHERE tab1.id = t1.id;
SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL
command not properly ended"
尝试使用合并
merge into table1 tab1
using
(
SELECT tab3.name, tab3."add", SUM(tab2.amount) AS total
FROM table2 tab2,
table3 tab3 ,
table4 tab4
WHERE tab2.id = tab3.id
AND tab3.id = tab4.id
AND tab4.indicator ='Y'
GROUP BY tab3.name,
tab3."add"
)t1
on(tab1.id = t1.id)
when matched then
update set tab1.total_adjusted_cost = tab1.total_adjusted_cost + t1.total
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
