Re: Use of IN operator

From: REIP Jean-Claude <jacari.consultant.noospaamm_at_skynet.be>
Date: 1997/11/24
Message-ID: <65cnql$2vm$1_at_news0.skynet.be>#1/1


Hi Arnaud,

Anytime it's possible, avoid usage of "IN" (to increase speed search)

Just for fun, try this :

     select equipment_id, equipment_de
     from equipment a
     where exists
             ( select 'X'
                 from equipment b
                 where a.equipment_id = b.equipment_id
                and a.equipment_de = b.equipment_de
                and b.ship_id = 'LOUISIANA' );

--
REIP Jean-Claude
Enlevez ".remove.this" de l'adresse (anti-spam)
jacari.consultant.remove.this_at_skynet.be
Arnaud martin wrote in message <34739094.42AF_at_cs.uno.edu>...

>Hi every body,
>
>
>I would to use an operator 'IN' with two columns:
>
> select equipment_id, equipment_de
> from equipment
> where equipment_id, equipment_de in
> ( select equipment_id, equipment_de
> from equipment
> where ship_id = 'LOUISIANA' );
>
>I got the following error message :
>
> "ORA 00920:invalid relational operator"
>
>Does anyone have an idea?
>
>Thank you very much for your help.
>
>Arnaud
Received on Mon Nov 24 1997 - 00:00:00 CET

Original text of this message