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.)
>

>>
>
>>I'm stumped! I've been looking at this too long I think. I am trying to create a temporary cursor of only those records in table (a) that have a record in table (b) AND whose table (b) field fontreq value =.t.
>>
>>Here is the structure/relationship:
>>
>>lcontrol table (a)
>>cn_name c(10) *--tag is name and is on UPPER(ALLTRIm(cn_name))
>>
>>ctrlset table (b)
>>ctrlname c(10) *--tag is ctrlname and is on UPPER(ALLTRIM(ctrlname))
>>fontreq L *--always .t. or .f. tag is fontreq
>>
>>lcontrol.cn_name has the same value as its related record in ctrlset.ctrlname
>>
>>Again, I want to create a temporary cursor that contains the field cn_name from the lcontrol table but it should only contain records that have a matching record in ctrlset *AND* whose fontreq field is .T.
>>
>>Here is what I've tried:
>>
>>Example 1:
>>

>>SELECT cn_name FROM lcontrol x WHERE ;
>>   EXISTS (SELECT * FROM ctrlset y WHERE x.cn_name = y.ctrlname)
>>

>>
>>The result from example 1 is that I get ALL records from the lcontrol table for some reason
>>
>>Example 2:
>>

>>SELECT cn_name FROM lcontrol x WHERE ;
>>   EXISTS (SELECT * FROM ctrlset y WHERE UPPER(ALLTRIM(x.cn_name)) = UPPER(ALLTRIM(y.ctrlname)))
>>

>>The result from example 2 is that I get an error message "ERROR CORRELATING FIELDS"
>>
>>If I were to do this using filters, it works correctly doing this:
>>
>>

>>SELE lcontrol
>>SET ORDER TO TAG NAME    && tag is ALLTRIM(UPPER(cn_name))
>>SELE ctrlset
>>SET ORDER TO TAG CTRLNAME    && tag is ALLTRIM(UPPER(ctrlname))
>>SET FILTER TO ctrlset.fontreq=.T.
>>SELE lcontrol
>>SET RELATION TO cn_name INTO ctrlset
>>SET FILTER TO FOUND('ctrlset')
>>

>>
>>This shows the correct records, but I need a select statement so I can have a temporary cursor to use and also not disrupt the dataenvironment (relationships) already in place.
>>
>>I've tried a BUNCH of other SQL statements, but I think I've just looked at this too much and its all blurry!!!!
>>
>>Any ideas?
>>THANKS in advance,
>>Tracy