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.”
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.”