Re: To write a query without using a sub query

From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Tue, 17 Jul 2001 17:04:06 +0400
Message-ID: <9j1cps$cnd$1@news247.cnt.ru>

Hello!

Try this:

SELECT a.emp_name FROM emp a, supervisor b WHERE a.emp_num > 0
and a.emp_num!=b.supervisor_emp

Best regards!
Yaroslav.

Prasad Kulkarni <prasad.kulkarni_at_mailcity.com> ñîîáùèë â íîâîñòÿõ ñëåäóþùåå:a8274029.0107170449.241355b4_at_posting.google.com...
> Hello all,
>
> I am using a free database called 'MySql'. But unfortunately it does
> not support sub queries. Can some one help me to write the query
> without using the sub query.
> For example, my query is something like this:
>
> SELECT emp_name FROM emp
> WHERE emp_num > 0
> and emp_num NOT IN (SELECT supervisor_emp FROM supervisor).
Received on Tue Jul 17 2001 - 08:04:06 CDT