Re: Exist

From: Scott Watson <swatson_at_datachest.com>
Date: Fri, 10 Aug 2001 13:33:57 -0400
Message-ID: <7SUc7.49742$5c.3666659@news20.bellglobal.com>

Depends are you selecting any data from table 1?

Scott.

"Sulejman Velic" <sule_at_optima.ba> wrote in message news:9l0kj3$5iq7_at_ns4.bih.net.ba...
> Hi all
>
> I have the falloving query:
>
> select *
> from table1 a, table2 b
> where a.column_1=b.column_1
> and a.column_x in ('1','2','3','5','17','20')
>
> Can I write this query usnig EXIST
> instead of IN operator.
>
> Thanx
>
>
Received on Fri Aug 10 2001 - 12:33:57 CDT