Oracle Les06_显示多个表中的数据.pptxVIP

显示多个表中的数据;Objectives;获得多个表中的数据;联结类型;使用Oracle SQL:1999 语法将表联结起来;限定模糊的列名;创建自然联结;SELECT department_id, department_name, location_id, city FROM departments NATURAL JOIN locations ;;SELECT department_id, department_name, location_id, city FROM departments NATURAL JOIN locations ;;SELECT department_id, department_name, location_id, city FROM departments NATURAL JOIN locations WHERE department_id IN （20，50）;;通过USING子句创建联结;用于联结的列名;SELECT employee_id, last_name, location_id, department_id FROM employees JOIN departments USING (department_id) ;;SELECT l.city, d.dep