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!