Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sub-query issue on pre-test

Re: Sub-query issue on pre-test

From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 23 Oct 2003 22:06:35 +0200
Message-ID: <bn9bua$en4$1@news2.tilbu1.nb.home.nl> 





spamintoreceptacle_at_yahoo.com wrote:



> Exactly! You have it right on the head - this is what is confusing me.

<snip!>



Get me the employee numbers of those employees not in dept 30,
that have the same salary and commission as employees in dept 30.



It's the salary/commision that's the driving criteria,
not dept=30 and dept <>30


-- 
Regards, Frank van Bortel


Received on Thu Oct 23 2003 - 15:06:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US