SQL Server中有
update t1 set col1=t2.col1,col2=t2.col2,col3=t2.col3 from t2 where t1.col_primary=t2.col_primary
在Oracle中对应语法是什么? 高手來看看啊............
update t1 set col1=t2.col1,col2=t2.col2,col3=t2.col3 from t2 where t1.col_primary=t2.col_primary
在Oracle中对应语法是什么? 高手來看看啊............
set (Col1, Col2, Col3) = ( select Col1, Col2, Col3 from t2
where t1.Col_Primary = t2.Col_Primary );
select t2.col1, t2.col2, t2.col3
from t2
where t1.col_primary=t2.col_primary