search

Home >Database >Mysql Tutorial >sql多表关联查询语句

sql多表关联查询语句

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 17:48:301737browse

本文章来告诉你在mssql server中的多表联合查询效果，有需要的朋友可以参考一下。

#temptest1                 #temptest2

   

实现方法如下：

 代码如下 复制代码

Update t1

Set t1 .age = t2.age

From  #temptest1 t1

Join #temptest2 t2

On  t1.id = t2.id

 

(补充)Sql Server 2008 Merge命令写法：

merge into #temptest1 t1
using( age,id from #temptest2) t2
on t1.id = t2.id
when matched then
update set t1.age = t2.age

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mssql server自动定时数据库备份图文详细Next article：SQL Server 身份验证标准连接：

Related articles

See more