>>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 >> >>>
>select maillist.* ; >from maillist ; >inner join >(select dist personid from list_members where list_id>67) crsTemp ; >on crsTemp.personid = maillist.personid ; >order by companyThanks Naomi. I was close but didn't know how to name the derived table. ( I had it inside the ())