How do you find the "unmatched" fields in a join
From: KnighThing <knighthing_at_hotmail.com>
Date: Fri, 08 Jun 2001 09:33:24 -0500
Message-ID: <s2o1itsb60l4b7huvqfempgf4v8nlftd54_at_4ax.com>
Date: Fri, 08 Jun 2001 09:33:24 -0500
Message-ID: <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?
AND emp.deptno is null? Received on Fri Jun 08 2001 - 16:33:24 CEST