select distinct callrepid from callreport where ; actionid1 in (select actionid from actions) ; or actionid2 in (select actionid from actions) ; ... or actionid10 in (select actionid from actions)>I have two tables as follows:
>callreport.dbf >callrepid actionid1 actionid2 ... actionid10 .... > > >actions.dbf >actionid action >>