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

Yes, use derived tables:

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