1、自然连接:可以理解为等值连接,它会帮你自动查询两张连接表中所有相同的字段,然后进行等值连接
#SQL99语法的新特性1:自然连接
SELECT employee_id,last_name,department_name
FROM employees e JOIN departments d
ON e.`department_id` = d.`department_id`
AND e.`manager_id` = d.`manager_id`;
#在SQL99中可以写成:
SELECT employee_id,last_name,department_name
FROM employees e NATURAL JOIN departments d;
#新特性2:USING
SELECT employee_id,last_name,department_name
FROM employees e JOIN departments d
ON e.`department_id` = d.`department_id`
SELECT employee_id,last_name,department_name
FROM employees e JOIN departments d
USING (department_id);