表查询 状态
select * from tbl_dept d INNER JOIN tbl_emp e on d.id=e.id – 中 内
select * from tbl_dept d LEFT JOIN tbl_emp e on d.id=e.id – 中 左
select * from tbl_dept d LEFT JOIN tbl_emp e on d.id=e.id where e.id is null – 左
select * from tbl_dept d RIGHT JOIN tbl_emp e on d.id=e.id where d.id is null – 右
select * from tbl_dept d RIGHT JOIN tbl_emp e on d.id=e.id – 中右
select * from tbl_dept d LEFT JOIN tbl_emp e on d.id=e.id where e.id is null union
select * from tbl_dept d RIGHT JOIN tbl_emp e on d.id=e.id where d.id is null – 左 右
select * from tbl_dept d LEFT JOIN tbl_emp e on d.id=e.id union
select * from tbl_dept d RIGHT JOIN tbl_emp e on d.id=e.id – 全部