You're welcome. Ususaly, it is faster that the one that uses correlated query. However, only tests on the real data can tell what the difference is.
>Thanks Sergey, your example worked very well. Since I am only pulling about 15-20 records out of 700, I don't know if there would be a significant speed difference in either one (I cannot see a measureable difference). I suspect given all things being equal (broadband,distance,usage,etc) your statement would be MUCH faster.
>
>I'll use your example instead of the one I got working.
>
>THANKS AGAIN
>
>Tracy
>
>>Try
SELECT cn_name FROM lcontrol ;
>> WHERE cn_name IN ;
>> (SELECT ctrlname FROM ctrlset WHERE fontreq=.T.)
>>
--sb--