082-外连接

SELECT * FROM boys;
SELECT *FROM beauty;

SELECT b.name,bo.*
FROM beauty b
LEFT OUTER JOIN boys bo
ON b.boyfriend_id=bo.id;
#where
#having
#order

UPDATE boys SET userCP=NULL WHERE id=3;

SELECT b.name,bo.*
FROM boys bo
RIGHT OUTER JOIN beauty b
ON b.boyfriend_id=bo.id
WHERE bo.id IS NOT NULL;

#哪个部门没有员工，左外
SELECT d.*,e.employee_id
FROM departments d
LEFT OUTER JOIN employees e
ON d.department_id=e.department_id
#where e.employee_id is null;

#哪个部门没有员工，右外
SELECT d.*,e.employee_id
FROM employees e
RIGHT OUTER JOIN departments d
ON d.department_id=e.department_id
#where e.employee_id is null;

全外