SQL表连接Join含义

1.Join连接方式

---

• 内连接( inner join…on…)

  select * from A ( inner) join B on A.id=B.id;
  

• 左(外)连接（left join…on…)

  select * from A left (outer) join B b on A.id=B.id;
  

• 右(外)连接（right join…on…)

  select * from A right ( outer) join B on A.id=B.id;
  

• 全外连接（full join…on…)

  select * from A full join B on A.id=B.id;
  

• 交叉连接(cross join …on… )

     笛卡尔积，可不加 cross