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: To write a query without using a sub query

Re: To write a query without using a sub query

From: Gerard Lapidario <ghed9_at_netzero.net>
Date: Tue, 17 Jul 2001 21:10:21 GMT
Message-ID: <1R157.51$K42.658@burlma1-snr2>

"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:9j1cps$cnd$1_at_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.
>

This would not return the desired result (everytime a.emp_num!=b.supervisor_emp is true, emp_name will be returned).

> 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 - 16:10:21 CDT

Original text of this message

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