Re: Use of 'IN' operator

The syntax is incorrect. Anyway what you are trying to accomplish can be obtained from the following query...

select equipment_id, equipment_de
from equipment
where ship_id = 'LOUISIANA'

Santosh

-- 
sparmanand.removeit_at_msn.com
remove the words removeit from the e-m address

Arnaud martin <amartin_at_cs.uno.edu> wrote in article
<34739183.5150_at_cs.uno.edu>...


> Hi every body,

> 

> I am using Personal Oracle 7.2.

> 

> I would like 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


>