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

[Quoted] [Quoted] Does any body has some ideas about this question? [Quoted] 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 Wed Nov 18 1998 - 23:17:08 CET