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: Prasad Kulkarni <prasad.kulkarni_at_mailcity.com>
Date: 17 Jul 2001 21:33:42 -0700
Message-ID: <a8274029.0107172033.7227ed47@posting.google.com>

"Gerard Lapidario" <ghed9_at_netzero.net> wrote in message news:<1R157.51$K42.658_at_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).
> >
> >

Yes you are correct. The query does not return the desired results Received on Tue Jul 17 2001 - 23:33:42 CDT

Original text of this message

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