update TableSpace_B.Table_B set TableSpace_B.Table_B.Col_b= (select TableSpace_A.Table_A.Col from TableSpace_A.Table_A where TableSpace_B.Table_B.Col_b=TableSpace_A.Table_A.Col) where exists (select 'y' from TableSpace_A.Table_A where TableSpace_B.Table_B.Col_b=TableSpace_A.Table_A.Col)
update Table_B set Col_b =(select Col_a from [user.]table_A where Table_B.id =[user.]Table_A.id) 应该这样。如果不在一用户下。需要把用户名加上
-- 不需要指定表空间的. update Table_B B set B.Col_b = (SELECT A.Col_a FROM Table_A A WHERE A.id = B.id)
-- 改一下: update Table_B B set B.Col_b = (SELECT A.Col_a FROM user.Table_A A WHERE A.id = B.id) --user为Table_A的owner where exists (select 1 from user.Table_A where id = B.id) -- 要注意这个where条件
set TableSpace_B.Table_B.Col_b= (select TableSpace_A.Table_A.Col
from TableSpace_A.Table_A where TableSpace_B.Table_B.Col_b=TableSpace_A.Table_A.Col)
where exists (select 'y' from TableSpace_A.Table_A where TableSpace_B.Table_B.Col_b=TableSpace_A.Table_A.Col)
set Col_b =(select Col_a from [user.]table_A
where Table_B.id =[user.]Table_A.id)
应该这样。如果不在一用户下。需要把用户名加上
update Table_B B
set B.Col_b = (SELECT A.Col_a FROM Table_A A WHERE A.id = B.id)
update Table_B B
set B.Col_b = (SELECT A.Col_a FROM user.Table_A A WHERE A.id = B.id) --user为Table_A的owner
where exists (select 1 from user.Table_A where id = B.id) -- 要注意这个where条件