Re: Exist

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 10 Aug 2001 17:58:56 GMT
Message-ID: <3b7420ba.81090328@news.alt.net>

On Fri, 10 Aug 2001 14:35:29 +0200, "Sulejman Velic" <sule_at_optima.ba> wrote:

>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
>
>

Why would you want to use an EXISTS? The IN operator is fine, especially on such a small set of data.

Brian Received on Fri Aug 10 2001 - 12:58:56 CDT