Re: about this SQL query (newbie here)

Could you post the statement itself? Looks like simple join statement. Don't see reasons to have subqueries (both exists and not exists) if you have join already.

In article <3A828F3B.33D3E_at_hotmail.com>,   " srcnckpc"_at_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
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 08 2001 - 22:57:23 CET