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