SQL语句中左(右)链接辨析

来源:互联网 发布:黑客入侵用什么软件 编辑:程序博客网 时间:2024/05/23 00:10

SELECT count(*)
FROM employees e, departments d

SELECT count(*)
FROM employees e, departments d
WHERE e.department_id(+) = d.department_id ;

是有差别的。

“You use an outer join to also see rows that do not
meet the join condition.”

原创粉丝点击