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
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>...Received on Mon Nov 24 1997 - 00:00:00 CET
>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