export query = question ?

all,

export parfile contains

query=" "
tables(tab_a, tab_b)
tab_a, tab_b, TAB_C contain column x
TAB_C(big) tab_a and tab_b relative small.

question:
1. is it possible to have

query ="where x in (select 1 from tab_c where x=TAB_C.x)"

2. Is there a way of getting around this if correlated subquery is not possible?

3. I can not use following IN clause

   where x in (select x from tab_c)
   because select x from tab_c gives me 3 million rows and performance is    extremely poor.

thnx a lot
ted chyn Received on Thu Jan 31 2002 - 01:28:39 CST