mysql join操作

1.Inner join

Select <select_list>

 fromtablea a

inner join tableb b

on a.key=b.key

2.left join

Select <select_list>

From tableA A

Left join tableB B

ON A.Key=B.Key

3.right join

Select <select_list>

From tableA A

Right join tableB B

ON A.Key=B.Key

4.left join where

Select <select_list>

From tableA A

Left join tableB B

On A.Key=B.Key

Where B.Key is null

5.right join where

Select <select_list>

From tableA A

Left join tableB B

ON A.Key=B.Key

Where A.Key is null

6.full outer join

Select <select_list>

From tableA A

Full outer join tableB B

On A.Key=B.Key（mysql不支持这种）

MYSQL中表示：

select * from tbl_dept d left JOIN tbl_emp e ON d.id=e.deptId
UNION
select * from tbl_dept d right join tbl_emp e ON d.id=e.deptId

7.full outer join where

Select <select_list>

From tableA A

Full outer join tableB B

On A.Key=B.Key

Where A.Key is null

Or B.Key is null