MySQL (+), the meaning?

Question

SELECT d.deptname, d.deptlocation, e.empname
FROM payroll.employee e, payroll.department d
WHERE e.deptno(+) = d.deptno
ORDER BY d.deptname, e.empname;

What does the (+) mean? Is that mean from employee table deptno Can be null?

you can get more details at http://stackoverflow.com/questions/6559261/left-outer-join-using-sign-in-oracle-11g — Deepika Janiyani, Nov 08 '13 at 06:11

score 3 · Answer 1 · answered Nov 08 '13 at 06:27

3

this is an old ORACLE-syntax to create OUTER JOINs. in your case, it means the same as

[...]
FROM
  payroll.department d
LEFT OUTER JOIN
  payroll.employee e
ON
  e.deptno = d.deptno
[...]

as others said in the comments, it's not valid in MySQL.

answered Nov 08 '13 at 06:27

oezi

49,639
10
95
114

MySQL (+), the meaning?

1 Answers1