一、查询插入:
insert into table_a(account) select user_id from table_b;
二、查询更新:
Update dbo.table_1
set dbo.table_1 .project_code=dbo.table_2.project_code
FROM dbo.table_1 , dbo.table_2 where
dbo.table_1.project_name=dbo.table_2.project_name;
一、查询插入:
insert into table_a(account) select user_id from table_b;
二、查询更新:
Update dbo.table_1
set dbo.table_1 .project_code=dbo.table_2.project_code
FROM dbo.table_1 , dbo.table_2 where
dbo.table_1.project_name=dbo.table_2.project_name;