mysql join

 

  select * from A innner join B on A.key = B.key;

 

     select * from A left join B on A.key = B.key;

 

     select * from A right join B on A.key = B.key;

 

    select * from A left join B on A.key = B.key where B.key is null;

    select * from A right join B on A.key = B.key where A.key is null;

 

  

select * from A outer join B on A.key = B.key; 

 

SELECT * FROM tbl_dept LEFT JOIN tbl_emp ON tbl_dept.id = tbl_emp.deptId

UNION

SELECT * FROM tbl_dept RIGHT JOIN tbl_emp ON tbl_dept.id = tbl_emp.deptId;

 

  

select * A outer join B on A.key = B.key where A.key is null or B.key is null;

 

SELECT * FROM tbl_dept LEFT JOIN tbl_emp ON tbl_dept.id = tbl_emp.deptId WHERE tbl_emp.deptId IS NULL

UNION

SELECT * FROM tbl_dept RIGHT JOIN tbl_emp ON tbl_dept.id = tbl_emp.deptId WHERE tbl_dept.id IS NULL ;