SQL的Join、笔记···

这只是看原文的笔记、是原创吧···

原文地址：http://coolshell.cn/articles/3463.html

只是看没感觉的、动手写写吧、新手骚年····

--Create Database O
Create database O

use O 
 
--Create Table A + B 
Create Table [dbo].[TableA](
id int identity(1,1) primary key,
name varchar(20)
)
Create Table [dbo].[TableB](
id int identity(1,1) primary key,
name varchar(20)
)


--Insert 
insert into TableA(name)values('Pirate')
insert into TableA(name)values('Monkey')
insert into TableA(name)values('Ninja')
insert into TableA(name)values('Spaghetti')
select * from TableA

insert into TableB(name)values('Rutabaga')
insert into TableB(name)values('Pirate')
insert into TableB(name)values('Darth Vader') 
insert into TableB(name)values('Ninja')
select * from TableB


--Inner join
Select * from TableA A inner join TableB B On A.name=B.name  --Error_No_Where

--Full Outer Join
Select * From TableA A Full Outer Join TableB B On A.name=B.name 

--Left Outer Join
Select * from TableA A Left Outer Join TableB B On A.name=B.name

--Left Outer Join + Where
Select * from TableA A Left Outer Join TableB B On A.name=B.name Where B.id Is Null --Notice_B.id Is Null_No =

--Full Outer Join + Where +Or
Select * from TableA A Full Outer Join TableB B On A.name=B.name Where A.id Is Null Or B.id Is Null

--TableA * TableB
Select * from TableA A Cross Join TableB B