Hi E.R,

What about:

lcList = ["1000000221","1000000222","1000000223","1000000224"]

SELECT customer.email, customer.name ,customer.media, customer.custnum ;
    FROM current, customer ;
    WHERE INLIST(current.cnum,&lcList) ;
    AND customer.custnum = current.custnum ;
    INTO CURSOR a2

Hope this helps,
Gavin...

>I'm trying to get the query below to run quicker - what am I missing? I thought if it was indexed that Rushmore would speed this query up. I have custnum and cnum indexed. The nested query returns about 16,000 records pretty quickly, but it looks like the 'custnum in' doesn't benefit from Rushmore at all.
>
>

>lcList = ["1000000221","1000000222","1000000223","1000000224"]
>
>sele EMAIL,NAME,MEDIA,CUSTNUM from customer ;
> where custnum in (sele custnum from current where cnum IN (&lcList)) into cursor a2
>
>9306 records. A2 elapsed time: 240.333
>
>Rushmore optimization level for table customer: none
>Using index tag Cnum to rushmore optimize table current
>Rushmore optimization level for table current: full
>Joining table customer and table current using index tag Custnum
>

>
>TIA,
>
>E.R. Gilmore