SQL语句update的正确写法,目前我写的有问题。

2024-12-02 18:36:20
推荐回答(2个)
回答1:

update a
set a.ns_1 = b.ns_1,a.ns_2 = b.ns_2 ······
from tb_sl_final a,tmp_sl_final01 b
where a.name = b.name and a.date = trunc(sysdate - 1)

回答2:

晕,你真逗