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

Home -> Community -> Usenet -> c.d.o.tools -> Re: about this SQL query: newbie here

Re: about this SQL query: newbie here

From: Al Hetzel <alhetzel_at_bigfoot.com>
Date: Fri, 09 Feb 2001 00:15:41 GMT
Message-ID: <1FC8FA611AC02A82.F67274993ED21FFF.A774D2AB6767AA86@lp.airnews.net>

I am confused. It sounds like you want a query that includes all of the employees in a specific department and all of the employees that are not in a specific department.

Wouldn't that logically be all employees?

Al

On Thu, 08 Feb 2001 17:23:17 GMT, " srcnckpc"@hotmail.com wrote:

>Get a list of employees in a department. Include the employee's name and
>location in your display. Show also the employees who are not in that
>department.
>
>
>I combined the EXISTS and NOT EXISTS operator in my query(after joining
>the emp and the dept tables), ie, get all the employees who EXISTS in
>that dept and get all the employees who NOT EXISTS in that department.
>
>I get the result "No rows selected." Does this mean the two results are
>canceling each other? Can you suggest an alternate method?
>
>Thanks
>
>
Received on Thu Feb 08 2001 - 18:15:41 CST

Original text of this message

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