SQL 3种联合查询

[First]表                                                            [Second]表

       

 

-- 交叉连接，输出4*5条记录
select * from [First],[Second]
select * from [First] cross join [Second]

 

-- 内连接
select * from [First] F,[Second] S where F.B = S.B
select * from [First] F inner join [Second] S
on F.B = S.B

 

-- 左外连接
select * from [First] F left outer join [Second] S
on F.B = S.B

 

-- 右外连接
select * from [First] F right outer join [Second] S
on F.B = S.B

 

-- 左右外连接 --!
select * from [First] F full outer join [Second] S
on F.B = S.B