Re: How do you find the "unmatched" fields in a join
From: Peter Kho <pkho_at_gt.ca>
Date: 8 Jun 2001 13:30:35 -0700
Message-ID: <6f20df81.0106081230.379d2a99_at_posting.google.com>
Date: 8 Jun 2001 13:30:35 -0700
Message-ID: <6f20df81.0106081230.379d2a99_at_posting.google.com>
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