hlcX's Blog
my note!
Toggle navigation
hlcX's Blog
2.学习
4.群晖
5.CentOS7
6.rasperryPI
linux-mint
关于
归档
标签
SQL join 用于把来自两个或多个表的行结合起来
sql
join
2021-12-31 11:17:53
16
0
0
hlcx
sql
join
# 下图展示了 LEFT JOIN、RIGHT JOIN、INNER JOIN、OUTER JOIN 相关的 7 种用法 ![title](/api/file/getImage?fileId=61ce77813c9b99002a00000e) # 例子 ```js create table #a (af1 int) insert into #a select 1 insert into #a select 2 create table #b (bf1 int) insert into #b select 2 insert into #b select 3 select 'lwft join' x,a.*,b.* from #a a left join #b b on a.af1=b.bf1 select 'right join' x,a.*,b.* from #a a right join #b b on a.af1=b.bf1 select 'inner join' x,a.*,b.* from #a a inner join #b b on a.af1=b.bf1 select 'lwft join b is null' x,a.*,b.* from #a a left join #b b on a.af1=b.bf1 where b.bf1 is null select 'right join a is null' x,a.*,b.* from #a a right join #b b on a.af1=b.bf1 where a.af1 is null select 'full outer join' x,a.*,b.* from #a a full outer join #b b on a.af1=b.bf1 select 'full outer join a or b null' x,a.*,b.* from #a a full outer join #b b on a.af1=b.bf1 where a.af1 is null or b.bf1 is null drop table #a drop table #b ```
上一篇:
JIRA自建服务器如何重置用户密码
下一篇:
用命令来同步WIN系统时间
0
赞
16 人读过
新浪微博
微信
腾讯微博
QQ空间
人人网
提交评论
立即登录
, 发表评论.
没有帐号?
立即注册
0
条评论
More...
文档导航
没有帐号? 立即注册