>It's faster than JOIN.
Thanks, it's good to know.
>
>>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.)
>>>>>
If it's not broken, fix it until it is.
My Blog