SQL Server联合查询
来源:互联网 发布:大海网络传奇官网 编辑:程序博客网 时间:2024/06/09 20:57
JOIN: 如果表中有至少一个匹配,则返回行
LEFT JOIN: 即使右表中没有匹配,也从左表返回所有的行
RIGHT JOIN: 即使左表中没有匹配,也从右表返回所有的行
FULL JOIN: 只要其中一个表中存在匹配,就返回行
一、inner join
select city.name as 城市, area.name as 地区 from area
inner join city
on city.code = area.cityid
或者
select c.name,a.name from area as a
inner join city as c
on c.code=a.cityid
二、left join
select city.name as 城市,area.name as 地区 from area
left join city
on city.code = area.cityid
或者
select c.name as 城市,a.name as 地区 from area as a
left join city as c
on c.code = a.cityid
三、right join
select city.name as 城市,area.name as 地区 from area
right join city
on city.code = area.cityid
或者
select c.name as 城市,a.name as 地区 from area as a
right join city as c
on c.code = a.cityid
四、full join
select city.name,area.name from area
full join city
on city.code = area.cityid
--或者
select c.name,a.name from area as a
full join city as c
on c.code = a.cityid
表结构
City表
- CREATE TABLE [dbo].[city](
- [id] [int] NOT NULL,
- [code] [nvarchar](6) COLLATE Chinese_PRC_CI_AS NULL,
- [name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
- [provinceId] [nvarchar](6) COLLATE Chinese_PRC_CI_AS NULL
- ) ON [PRIMARY]
CREATE TABLE [dbo].[city]( [id] [int] NOT NULL, [code] [nvarchar](6) COLLATE Chinese_PRC_CI_AS NULL, [name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [provinceId] [nvarchar](6) COLLATE Chinese_PRC_CI_AS NULL) ON [PRIMARY]
Area表
- CREATE TABLE [dbo].[area](
- [id] [int] NOT NULL,
- [code] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
- [name] [nvarchar](60) COLLATE Chinese_PRC_CI_AS NULL,
- [cityId] [nvarchar](6) COLLATE Chinese_PRC_CI_AS NULL
- ) ON [PRIMARY]
- SQL Server联合查询
- SQL Server联合查询
- sql server 联合查询
- sql server 多字段联合查询
- SQL Server两表联合查询问题
- SQL server 多表联合查询
- SQL Server 多表联合查询取最新一条数据
- 关于sql联合查询
- Sql联合查询
- Sql联合查询
- Sql联合查询
- Sql联合查询
- sql 联合查询
- SQL联合查询
- sql联合查询
- sql联合查询详解
- SQL联合查询简介
- SQL 联合查询
- » Table of Hardware of OpenWrt
- 微软等100题系列
- C# 关于水仙花
- 一些iso 学习资源
- 沉下心来把php自学好
- SQL Server联合查询
- 不良资产的处理方式
- Sql Server索引
- Android Camera(一)
- 为啥不招北大清华的?
- 百万级数据查询优化
- Sql Server子查询、GROUP BY分组、having查询
- Android ApiDemos示例解析(162):Views->Layouts->TableLayout->07. Column Collapse
- Windows下安装MongoDB