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