Re: How do you find the "unmatched" fields in a join

No, in the query below, you are basically saying that give me a list of employees including
employees who are not assigned to a department.

If you want to get a list of departments that have no employees, you would write
your query with the (+) on dept.deptno as in

SELECT dept.deptno, dept.dname
FROM emp, dept
WHERE emp.deptno = dept.deptno(+)
AND emp.ename is NULL;

KnighThing <knighthing_at_hotmail.com> wrote in message news:<s2o1itsb60l4b7huvqfempgf4v8nlftd54_at_4ax.com>...
> In this example (from the Oracle documentation):
>
> SELECT ename, job, dname
> FROM emp, dept
> WHERE emp.deptno (+) = dept.deptno;
>
>
> How would I get the list of departments with no employees?
>
> i.e.
>
> AND emp.deptno is null?
Received on Fri Jun 08 2001 - 22:30:35 CEST