For you SQL gurus out there, is there a way this sequence could be combined into one command?
selectdist personid from list_members where list_id>67 intocursor crsTemp
select maillist.* ;
from maillist ;
inner join crsTemp ;
on crsTemp.personid = maillist.personid ;
orderby company