Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: about this SQL query: newbie here
I think so too. This was for an assignment and I am trying to clarify the question with the person concerned.
Al Hetzel wrote:
> 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 - 21:38:15 CST