How about something like..........

SELECT DISTINCT cr.callrepid FROM callreport cr,actions ac;
 WHERE ac.actionid IN (cr.actionid1,cr.actionid2,....,cr.actionid10)

It seemed to work ok on a very small mock-up of what you described



>I have two tables as follows:
>

>callreport.dbf
>callrepid   actionid1  actionid2 ...  actionid10 ....
>
>
>actions.dbf
>actionid    action
>

>
>I need an sql statement that will produce a cursor containing only the callrepids from callreport.dbf that have an actionid (1-10) that is in the actions dbf.
>
>Hope this makes sense.
>
>Thanks in advance for your help!