Wow. That's even shorter than Naomi's solution. I don't see anything about the IN in the VFP help. Is it documented anywhere?


>

>select maillist.* ;
> from maillist ;
> WHERE  personid IN (select personid from list_members where list_id > 67) ;
> order by company
>

>
>
>>For you SQL gurus out there, is there a way this sequence could be combined into one command?
>>
>>

>>select dist personid from list_members where list_id>67 into cursor crsTemp
>>
>>select maillist.* ;
>>from maillist ;
>>inner join crsTemp ;
>>on crsTemp.personid = maillist.personid ;
>>order by company
>>
>>