inner join、join区别
来源:互联网 发布:单簧管和长笛 知乎 编辑:程序博客网 时间:2024/06/01 23:51
SQL 几种
JOIN
用法实例
declare
@ta
table
(id
int
,va
varchar
(10))
declare
@tb
table
(id
int
,vb
varchar
(10))
insert
into
@ta
select
1,
'aa'
insert
into
@ta
select
2,
'bc'
insert
into
@ta
select
3,
'ccc'
insert
into
@tb
select
1,
'2'
insert
into
@tb
select
3,
'58'
insert
into
@tb
select
4,
'67'
--内连接简单写法
select
a.id,a.va,b.id,b.vb
from
@ta a,@tb b
where
a.id=b.id
--内连接
select
a.id,a.va,b.id,b.vb
from
@ta a
inner
join
@tb b
on
a.id=b.id
select
a.id,a.va,b.id,b.vb
from
@ta a
join
@tb b
on
a.id=b.id
--左连接(左外连接)
--返回left join 子句中指定的左表的所有行,以及右表所匹配的行。
select
a.id,a.va,b.id,b.vb
from
@ta a
left
join
@tb b
on
a.id=b.id
select
a.id,a.va,b.id,b.vb
from
@ta a
left
outer
join
@tb b
on
a.id=b.id
--右连接(右外连接)
--返回right join 子句中指定的右表的所有行,以及左表所匹配的行。
select
a.id,a.va,b.id,b.vb
from
@ta a
right
join
@tb b
on
a.id=b.id
select
a.id,a.va,b.id,b.vb
from
@ta a
right
outer
join
@tb b
on
a.id=b.id
--完整外连接
--等同左连接+右连接
select
a.id,a.va,b.id,b.vb
from
@ta a
full
join
@tb b
on
a.id=b.id
select
a.id,a.va,b.id,b.vb
from
@ta a
full
outer
join
@tb b
on
a.id=b.id
--交叉连接
--没有两个表之间关系的交叉连接,将产生连接所涉及的表的笛卡尔积。
select
a.id,a.va,b.id,b.vb
from
@ta a
cross
join
@tb b
select
a.id,a.va,b.id,b.vb
from
@ta a,@tb b
--自连接
--一个表和其本身连接。
select
a.id,a.va,b.id,b.va
from
@ta a,@ta b
where
a.id=b.id+1
0 0
- inner join、join区别
- LEFT JOIN,INNER JOIN区别
- left join,inner join区别
- left join /right join/inner join区别
- left join / right join /inner join 区别
- left join 、right join、inner join 区别
- Join,Inner Join,Left Join,Right Join,Full Join区别
- Join,Inner Join,Left Join,Right Join,Full Join区别
- inner join,outer join,left join,right join的区别
- inner join,outer join,left join,right join的区别
- inner join, left join, right join,all join区别
- inner join,outer join,left join,right join的区别
- join/inner join/left join/right join区别
- inner join, left join, right join, full join 的区别
- inner join, left join, right join, full join 的区别
- inner join, left join, right join, full join 的区别?
- Inner join,outer join,left join,right join的区别
- Inner join,outer join,left join,right join的区别
- javascript eval函数解析json数据时为什加上圆括号eval("("+data+")")
- Android 输入系统架构 笔记4
- java实现redis数据库访问
- 设置Java heap space内存大小
- TCP几个问题
- inner join、join区别
- 陈晓建-腾讯云网络虚拟化实践
- Intent传递对象的两种方法(Serializable,Parcelable)
- 关于sysfs的属性文件
- 圆角边的实现
- 滑动窗口与拥塞窗口
- android4.4对于下载里面有些apk文件无法打开的修改
- Spring框架4的改进
- Unity3D与Android相互传递消息