Re: Forms Question : How to avoid IN operator in the WHERE CLAUSE

From: Marc Billiet <Marc.Billiet_at_hae.hydro.com>
Date: Thu, 19 Nov 1998 07:40:13 +0100
Message-ID: <730eou$9gh$1_at_vkhdsu24.hda.hydro.com>


I think the following should work (if the base table of your block is Table1):

where exists (select 1 from Table2 where Table2.col2 = Table1.col1 and Table2.col2 like 'XYZ')

Another solution is to base your block on a view, eventually with a packaged variable representing the value of 'XYZ'.

Marc

"Madhu Cherukuri" wrote in message ...
>Hi,
>
>Does any body has some ideas about this question?
>I have a where clause which uses a sub-query and
>IN operator to perform the main query.
>Thsi is causing Full Table scan and I want to
>avoid it. Is there any workaround for this in the
>Forms?(Forms 4.5)
>
>Where clause is like this
>
>where col1 IN (select col2 from Table2 where col2 like 'XYZ')
>
>Col1 is from another table and has a relationship with col2 of Table2
>
>Thanks in advance
>
>Madhu Cherukuri
>
>
>
> -**** Posted from Supernews, Discussions Start Here(tm) ****-
>http://www.supernews.com/ - Host to the the World's Discussions & Usenet
Received on Thu Nov 19 1998 - 07:40:13 CET

Original text of this message