数据库表连接（内连接，外连接【左连接、右连接、全连接】交叉连接）

等价于

select * from [book] as b inner join [student] as s on b.studentID=s.studentID

结果为：

2.左连接

select * from [book] as b left join [student] as s on b.studentID =s.studentID

结果

3.右连接

select * from [book] as b right join [student] as s on b.studentID = s.studentID

4.全连接

select * from [book] as b full out join  [student] as s on b.studentID = s.studentID

数据库表连接（内连接，外连接【左连接、右连接、全连接】交叉连接）

标签：idt   显示   红楼梦   表连接   bsp   结果   str   全连接   连接