JOIN:
1. Natural join:自然连接,ORACLE 自动根据两表中类似的列进行连接;
2. Outer join:Left outer join、Right outer join、Full outer join
Left outer join:from 后面的表显示完整;
Right outer join:join 后面的表显示完整;
Full outer join:两边均显示完整;
多表查询中如果缺少数据的列补充(+),如果改写成left outer join则是相反的。
例如:
有两个表employees,departments
如果是departments中的department_id少
则写法如下:
SELECT last_name, department_name
FROM employees e
LEFT OUTER JOIN departments d ON (e.department = d.department_id);
SELECT last_name, department_name
FROM employees e,departments d
WHERE e.department = d.department_id(+);
3. Cross join:笛卡尔积
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24751738/viewspace-707527/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24751738/viewspace-707527/