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