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