It's faster than JOIN.

>Is it the same, as INNER join?
>
>>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.)
>>>>