SQL语句 把从一个表中查出来数据插入到另一个表中

 

 

insert into T_annual(year,userid,username) select hryear,userid,username from T_annualleavebase where ...

 sqlserver：

 

update train_plan_record  

set college_name= a.college_name

from college_records a  ,train_plan_record p 

where

 convert(nvarchar(255),p.college_code)=convert(nvarchar(255),a.college_code)

 

oracle：

merge into UC_USER  

using dealer  

on(UC_USER.dealerid=dealer.dealerid)  

when matched then  

update set UC_USER.cellphone = dealer.cellphone