Question

oracle 中用一个表的字段update另一个表的字段值怎么做

Answer 1

where
exists
(
select
1
from
(
from
(select
rownum
rn,
t.*
from
m_chargepole_real
t
那行多了
from
（
where
exists
(
select
1
from
（select
rownum
rn,
t.*
from
m_chargepole_real
t
一个sql都一天了还没搞定
有问题私聊我

Answer 2

举例(一对一,tablea所有关联数据全部修改)：
update
tablea
set
column_name1=(select
name2
from
tableb
where
tableb.name3=tablea.name1)
只修改一个
update
tablea
set
column_name1=(select
name2
from
tableb
where
tableb.name3='a')
where
tablea.name1='A'
仅为举例不能生搬硬套